[Resolved] too many set updates?!

[tuf-web_co_uk]

hey this debugging this is coming along well......

right i have a query like so many of us do (what is the meaning of life maybe?!) !

<?
$search = ("UPDATE custom set table='$table', bgcolor='$bgcolor', 

			fontface='$fontface', fontsize='$fontsize', fontcolor='$fontcolor', 

			link='$link', active='$active', visited='$visited', hover='$hover', 

			linksize='$linksize', linkface='$linkface' WHERE username='$user'");

			$style = mysql_query($search, $conn) or die("could not update styles");?>

this gives me the error message "could not update styles" brought from the die command

however if i remove the set update table='$table' then my code works

<?
$search = ("UPDATE custom set bgcolor='$bgcolor', 

			fontface='$fontface', fontsize='$fontsize', fontcolor='$fontcolor', 

			link='$link', active='$active', visited='$visited', hover='$hover', 

			linksize='$linksize', linkface='$linkface' WHERE username='$user'");

			$style = mysql_query($search, $conn) or die("could not update styles");
?>

can anyone please tell me why this is happening or if there actually is a limit to how many update sets can be in 1 sql query

thanks Jon 🙂

[ahundiak]

Table is a reserved word.
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Reserved_words
Either change it or use back ticks.

[tuf-web_co_uk]

ah now i see the problem

thanks very much 😃