unable to update mysql

[xanie]

I've check all the values but still it is unable to update mysql data..

 

help pls.. thanks a bunch..

 

mysql_query("UPDATE warranty SET
 date_purchased_month ='$month',
 date_purchased_day ='$day',
 date_purchased_year ='$year',
 full_name ='$fullname',
 address	 ='$address',
 city	 ='$city',
 email	 ='$email',
 gender	 ='$gender',
 age_group ='$agegroup',
 model	 ='$model',
 lens	 ='$lens',
 frame	 ='$frame',
 price_paid ='$ppaid',
 how_did_you_hear ='$how',
 where_did_you_buy ='$where',
 performance ='$performance',
 value	 ='$value',
 quality	 ='$quality',
 suggestions ='$suggestions'

 WHERE warranty_id ='$id'")or die(mysql_error("Unable to edit");

Edited February 15, 2013 by xanie

[Jessica]

You shouldn't put quotes around numeric values.

You need to capture the mysql error.

[Barand]

... and the code doesn't even parse correctly - missing a ")" right at the end.