[RESOLVED] MySQL Error makes no sense

[PureDrive]

Hi, I get this error and I can't figure out why, I don't see any problem with my query, do you? The error is:

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 'set, reps, weight, rest, timestamp) VALUES('1','1','1','1','25','0','1',UTC_TIME' at line 1

And my query is:

$query = "INSERT INTO report_strength(user_id, exercise_id, exercise_type, set, reps, weight, rest, timestamp) VALUES(" .
 "'" . $this->user_id . "','" . $exercise_id . "','" . $exercise_type . "','" . $set . "','" . $reps . "','" . $weight . "','" . $rest . "'," . "UTC_TIMESTAMP())";

Thanks

[burfo]

The word "set" is a keyword reserved by MySQL. You shouldn't use it as a table or column name. If you must use the column name "set", then you need to quote it with backticks.

http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

[PureDrive]

Thanks burfo, I got it.