SQL Error

studioh3o

I was wondering if anybody could give me a hand on figuring out what this error is talking about...

You have an error in your SQL syntax near ''cart' SET qty = '22' WHERE itemid='H_integrityblk' AND size='' AND color=''' at line 1

any help would be great....

Mike

HalfaBee

Post the whole sql statement.

HalfaBee

studioh3o

uhh duhh that might help...lol sorry about that... here it is....
case "update_item":
$sql = "UPDATE 'cart' SET qty = '$qty' WHERE itemid='$itemid' AND size='$size' AND color='$color'";
if(!(mysql_query($sql))){
echo mysql_error();
die();
}

Mike

jimson

$sql = "UPDATE 'cart' SET qty = '$qty' WHERE itemid='$itemid' AND size='$size' AND color='$color'";

change to

$sql = "UPDATE cart SET qty = '$qty' WHERE itemid='$itemid' AND size='$size' AND color='$color' ";

studioh3o

ok i changed what you guys said to cahnge and now when i change the quantity and click the update button the total amount doesn't update and the quantity goes back to the default "1". any help would be great... thank in advance.

Mike

jimson

in order to help me to help u solve the problem

please DESC cart in mysql console, copy it and paste it in this thread
or u can trouble shot yourself

method a:
enter the mysql console
type the SQL statement (which we changed already) directly
and see whether the assume affected row updated successfully or not.

method b:
if the SQL statement can be updated successfully in the console mode of mysql, this mean something wrong with your script,
most probably is that
$qty, $itemid,$size and $color don't have value.

i read ur first post in this thread, i suppose $size and $color don't have value.
please check ur size and color columns, maybe u already set the columns to have a default value set up.

studioh3o

actually i figured it out, thanks for the help though...

Mike

trooper

Great that you have fixed it ... how about putting th solution here so that others who have similar problems can read this thread and see the solution ... oh and also set the thread to resolved.