xanie Posted February 15, 2013 Share Posted February 15, 2013 (edited) 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 Quote 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. Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/274507-unable-to-update-mysql/#findComment-1412582 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.