What's wrong with my SQL query?

[Username:]

I can't seem to find anything wrong with it, but it keeps giving me 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 'desc,img,vid) values('1','3','img/1299254331.PNG','2')' at line 1

 

My query:

include('includes/connect.php');
mysql_query("INSERT INTO ".$c[1]." (seed,desc,img,vid) values('$seed','$desc','$final','$vid')") or die(mysql_error());

 

EDIT:

Nevermind, -apparently- you can't have a row called desc, or it thinks it means descending sort.

[Maq]

Yep, check out:

http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html

[Muddy_Funster]

that's not the best practice, you should assign your SQL string to a variable and then execute the mysql_query() against the variable.  try this:

$qry ="INSERT INTO ".$c[1]." (seed, desc, img, vid) values('$seed', '$desc', '$final', '$vid')"; 
mysql_query($qry) or die($qry.'<br>Failed to run due to the following error :<br>'.mysql_error());

and see how you get on.

[The Little Guy]

desc is a mysql command you shouldn't use that as a column name. if you do you should put tick marks around it, like so:

 

mysql_query("INSERT INTO ".$c[1]." (seed,`desc`,img,vid) values('$seed','$desc','$final','$vid')") or die(mysql_error());