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()); }

Comments

Post a Comment

Popular posts from this blog

Unable to remove the www from url on https using .htaccess -

-
i want remove www site url. ie. https://www.domainname.com.au https://domainname.com.au . i have tried various .htacces code nothing work me. here present code remove www http not work https. rewriteengine on rewritebase / rewritecond %{http_host} ^www\.(.*)$ [nc] rewriterule ^/(.*)$ http://%1/$1 [r=301,l] rewritecond %{https} off rewriterule ^(.*)$ https://domainname.com.au/$1 [r=301,l] rewriterule ^code-of-conducts/(.*)/$ code-of-conducts.php?type=$1 rewriterule ^parents/post-a-job/(.*)/edit/$ parents/post-a-job.php?action=edit&id=$1 rewriterule ^parents/post-a-job/(.*)/$ parents/post-a-job.php?job_type=$1 rewriterule ^parents/open-jobs/(.*)/delete/$ parents/open-jobs.php?action=delete&id=$1 rewriterule ^parent-profile/(.*)/$ parent-profile.php?id=$1 rewriterule ^parents/job-details/(.*)$ parents/job-details.php?applied_id=$1 rewriterule ^sitterprofile/(.*)/$ sitterprofile.php?id=$1 rewriterule ^sitter/job-board/state/(.*)/page/(.*)/$ sitter/job-board.ph...
Read more