[SOLVED] What's wrong with my query?

[iPixel]

It's a simple POST from a dynamic form to a page that collects them.

type sent as <input... name="type[]" id="type[]">

 

All the data goes through and is collected no problem, but my bloody sql query craps out and i do not see a reason why.

 

Here's the query.

<?php
$query = "UPDATE tablename SET type = '$type[$x]', price = '$price[$x]', desc = '$desc[$x]', link = '$link[$x]' WHERE id = '$id[$x]'";
?>

 

 

Here is the 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 = 'descriptions for the purchase item' at line 1

 

Thanks

For the help!

[Bricktop]

Hi iPixel,

 

'desc' is a MySQL reserved word.  You can use it but you will need to escape it with backticks `.  See http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html for more information.

 

So your code needs to read:

 

<?php
$query = "UPDATE tablename SET type = '$type[$x]', price = '$price[$x]', `desc` = '$desc[$x]', link = '$link[$x]' WHERE id = '$id[$x]'";
?>

[iPixel]

Ok i feel like a chump, i actually knew that but it completely kept missing me lol. TY!