php - MySQL: Unknown column 'XYZ' in 'field list' -
i have big problem. dont know why, on 2 days when make this: $date_current = date('y-m-d h:i:s'); $mysql = @mysql_query("update aso_repairs set repairs_date_end = '$date_current', repairs_sendnoticer_email_end = 'sending', repairs_sendnoticer_sms_end = 'sending' repairs_id = '$repairs_id' "); if (!$mysql) { die(mysql_error()); } i error: unknown column 'repairs_sendnoticer_email_end' in 'field list'. this column exist in table (structure pastebin.com/cw42nc3n). problem? try this: $date_current = date('y-m-d h:i:s'); $mysql = @mysql_query("update aso_repairs set repairs_date_end = \"'$date_current'\", repiars_sendnoticer_email_end = 'sending', repiars_sendnoticer_sms_end = 'sending' repairs_id = '$repairs_id' "); if (!$mysql) { die(mysql_error()); }