请检查此SQL查询是否正确

Question

I am trying to update the data in a row of a table which by specific user ID. But I am receiving syntax error. Could anyone tell me what's the wrong in the syntax or I miss something ?

Result of an echo statement --->

UPDATE activitymeter SET totaltimes = 4, tna_wd = 1, tnm_wd = 10, tna_we = 10, tnm_we = 10, mvpa_wd = 2, mvpa_we = 5, week_diff = -3, tailor_advice= Your weekday activity level is below the recommended levels but it looks as though this is improved on a weekend. WHERE user_id = 2227904 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'weekday activity level is below the recommended levels but it looks as though th' at line 10

Answer 1

I always use more complete syntax (include all back-ticks for table names, etc) like so:

$intotable = "UPDATE `activitymeter` SET `update_totaltimes` = '".$totalactivity."', `update_tna_wd` = '".$timeweekday."', `update_tnm_wd` = '".$totalweekday."', `update_tna_we` = '".$timeweekend."', `update_tnm_we` = '".$totalweekend."', `update_mvpa_wd` = '".$mvpaweekday."', `update_mvpa_we` = '".$mvpaweekend."', `update_week_diff` = '".$dayenddifference."', `update_tailor_advice` = '".$tailoradvice."', `timestamp_column` = '".$tsnow."' WHERE `user_id` = '".$userid."';";