INSERT syntax

[ernest1a]

I spent today 2 hours because of "`" sign. Before that I used statement

mysql_query("INSERT INTO users (uTitle, uValue, UserID) VALUES ('$value1', '$value2', 'value3')"); and it worked.

But today I created new table and this sytax didn't work. I tried almost everything, putting ' or " in any combination.

 

Finally I realized I should use ` instead of ' or instead of without. mysql_query("INSERT INTO friend_requests (username, `by`) VALUES ('7', '2')");

 

Now I got really confused why before and after by the "`" is needed? And why not also in username. And why ' is not working or without, I saw also in W3SCHOOLS is without.

 

Thank you

[rhodesa]

BY is a reserved word in MySQL. you should avoid using it as a field name. the ` tells MySQL to treat it as a field instead of MySQL keyword.

 

here is a list of reserved words: http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html