[SOLVED] Mysql error

[shotos]

hi

i got this mysql query

 

$input = "INSERT INTO category(name, By) VALUES('$category','$_SESSION[user]')";
     $write = mysql_query($input,$db->link) or die(mysql_error() . " Query was: $input");

 

which generates 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 'By) VALUES('Grain','kwasi')' at line 1

Query was: INSERT INTO category(name, By) VALUES('Grain','kwasi')

 

problem is i dun see de error...

thanks in advance

 

 

[mtoynbee]

Try this instead:

 

$input = "INSERT INTO category([name], [by]) VALUES('$category','$_SESSION[user]')";
     $write = mysql_query($input,$db->link) or die(mysql_error() . " Query was: $input");

 

"BY" is a reserved word therefore is needs square brackets for MySQL to treat it as a column name.

[JasonLewis]

It's better to not name columns as a reserved word, IMO. For future reference, a list of reserved words can be found here.

[shotos]

thnks

i replaced 'By' with sumtin else.