xanie Posted February 15, 2013 Share Posted February 15, 2013 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"); Link to comment https://forums.phpfreaks.com/topic/274507-unable-to-update-mysql/ Share on other sites More sharing options...
Jessica Posted February 15, 2013 Share Posted February 15, 2013 You shouldn't put quotes around numeric values. You need to capture the mysql error. Link to comment https://forums.phpfreaks.com/topic/274507-unable-to-update-mysql/#findComment-1412554 Share on other sites More sharing options...
Barand Posted February 15, 2013 Share Posted February 15, 2013 ... and the code doesn't even parse correctly - missing a ")" right at the end. Link to comment https://forums.phpfreaks.com/topic/274507-unable-to-update-mysql/#findComment-1412582 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.