Craig: I don't see a reply to your question in today's posts.
"Backticks" or "tick marks" allow you to use reserved words for column names. Interval is a reserved word.
Hope you weren't waiting this long for a response.
Doug Thompson
Craig Hoffman wrote:
Why is it when I have this ` tick mark in my query it works fine, but when I remove them it I get an error?
Error: 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 'interval, heartrate, morning_hr, hr_for_intervals, watts, rpms,
Here is my query:
$query = "INSERT INTO traininglog ( `user_id` , `power_level` , `weight` , `comments` , `workout` , `distance` , `time` , `interval` , `heartrate` , `morning_hr` , `hr_for_intervals` , `watts` , `rpms` , `date` , `time_upload` , `week_of` , `sleep` , `motivation` , `workout_name` , `rpe` , `candence` , `crunchs` , `leg_raises` , `situp_with_twist` , `superman` , `situps` , `russian_twist` , `back_extensions` , `situp_crunchs` , `side_crunchs` , `balance_bicycles` , `v_ups` , `leg_rotation` , `medicine_ball_throw` , `pull_ups` , `push_ups` , `climbing` ) VALUES ($_POST[user_id], '$_POST[power_level]', $_POST[weight], '$_POST[comments]', '$_POST[workout]', '$_POST[distance]', '$_POST[time]' '.'
'$_POST[interval]', $_POST[heartrate], $_POST[morning_hr], $_POST[hr_for_intervals], $_POST[watts], $_POST[rpms], $_POST[date], NOW('$_POST[time_upload]') '.'
'$_POST[week_of]', $_POST[sleep], '$_POST[motivation]', '$_POST[workout_name]', $_POST[rpe], $_POST[candence], $_POST[crunchs], $_POST[leg_raises], $_POST[situp_with_twist] '.'
$_POST[superman], $_POST[situps], $_POST[russian_twist], $_POST[back_extensions], $_POST[situp_crunchs], $_POST[side_crunchs], $_POST[balance_bicycles], $_POST[v_ups] '.'
'$_POST[leg_rotation]', $_POST[medicine_ball_throw], $_POST[pull_ups], $_POST[push_ups], '$_POST[climbing]' )";__________________________________
Craig Hoffman - eClimb Media
v: (847) 644 - 8914 f: (847) 866 - 1946 e: choffman@xxxxxxxxxx w: www.eclimb.net _________________________________
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
