mysql update query

[Stooney]

having some probs, just checking my syntax:  (mysql 5)

 

$query=("UPDATE `stauctioneer_tableitems` SET `itemnum`='1' WHERE `table` = '11' AND `slot`='1'");

[BenInBlack]

why are you quoting what appears to be integer columns

='1'

= '11'

 

"UPDATE stauctioneer_tableitems SET itemnum = 1  WHERE table = 11 AND slot=1"

[Stooney]

well those are generally variables, that line was the result of my printing the query.  so pre-print:

 

	$update="UPDATE `stauctioneer_tableitems` SET `itemnum`='$slot[$k]' WHERE `table` = '$tableid' AND `slot`='$k'"; 

[noidtluom]

well those are generally variables, that line was the result of my printing the query.  so pre-print:

 

	$update="UPDATE `stauctioneer_tableitems` SET `itemnum`='$slot[$k]' WHERE `table` = '$tableid' AND `slot`='$k'"; 

 

Remove the single quotes around the variables.

[revraz]

Syntax looks right, what error do you get?

 

If its just not updating, make sure you are in fact sending the right type of data for that column.  If they are all set to Integer, make sure your variables are not Strings.

 

Put a error check after the query to see if you have a error in your statement.