PHP syntax error adding data to MySQL db

Question

trying to add data to mySQL db.

I get this error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MATCH(time, date, location, weather, team_id) VALUES('t', 't', 't','t','2')'

this is the PHP code snippet:

$sql = "insert into MATCH(time, date, location, weather, team_id) VALUES('$time', '$date', '$location','$weather','$team_id')";

I cant see any syntax errors

If MATCH is your table name, then you need to enclose it in backticks because it's also a MySQL reserved word - dev.mysql.com/doc/refman/5.6/en/reserved-words.html — Mark Baker
– Mark Baker, Commented Jan 28, 2014 at 20:09

jonathanglima · Accepted Answer · 2014-01-28 20:09:41Z

3

MATCH is a reserved for a function used in fulltext search:

http://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html

That's not a php syntax error. It's a Mysql syntax error. I suggest changing the table's name.

answered Jan 28, 2014 at 20:09

jonathanglima

4391 gold badge4 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Chris Mowbray Over a year ago

thanks, what is the correct syntax for naming tables i.e. rugby_Match, rugby_match etc...

Funk Forty Niner Over a year ago

There is an alternative to just changing the table's name. Maybe the OP likes the name. ;-) - Offering the same "deal" here too.

Funk Forty Niner · Accepted Answer · 2014-01-28 20:39:42Z

2

Try

$sql = "INSERT INTO `MATCH` (`time`, `date`, `location`, `weather`, `team_id`) VALUES ('".$time."', '".$date."', '".$location."','".$weather."','".$team_id."')";

Using the backtick character ` you can distinguish names you gave to your table or columns from reserved words of the MySQL language. Leaving them out might seem more compfortable at first, but can be a pain later.

E.g. one should know that mysql syntax is not case sensitive. So even if you write match you will get this problem. A list of the reserved words can be found at the link Mark gave you in his comment.

You might also want to read up on MySQL Syntax in general:

http://dev.mysql.com/doc/refman/5.1/en/sql-syntax.html

edited Jan 28, 2014 at 20:39

Funk Forty Niner

74.2k14 gold badges71 silver badges146 bronze badges

answered Jan 28, 2014 at 20:11

Simeon

4081 gold badge7 silver badges17 bronze badges

4 Comments

Funk Forty Niner Over a year ago

If you add the reason why and a fair explanation, I might even +1 this. Saying just Try isn't enough, not in my books anyway ;-)

Funk Forty Niner Over a year ago

Oh come now, you can do better than that. Read Mark Baker's comment, and learn ;-)

Simeon Over a year ago

Sorry, but I didn't want to copy Marks answer. He was faster, but when I saw his comment I already pushed backtick so often that I wanted to give him the code anyway ^^

Funk Forty Niner Over a year ago

No problemo (no permanent damage done) - It was just a comment (notice the word if in his comment). Sometimes people don't want to bother putting in answers for questions as such. Plus, they tend to open up a potential "Can of Worms". Will upvote this, but in the future, do try to make answers as informative as possible. It's beneficial for all, plus you stand at getting more upvotes. ;-)

Collectives™ on Stack Overflow

PHP syntax error adding data to MySQL db

2 Answers 2

2 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related