Lamez Posted August 7, 2009 Share Posted August 7, 2009 Okay, I am getting a error with my query. I am sure it's nothing, but I cannot find it. I just need a fresh pair of eyes. Here is the 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 'key, ip, first, last, email, disp, review) VALUES ('0', '6a4c85fbb4772a41f645b8a' at line 1 Here is the code: <?php $q = "INSERT INTO `reviews` (valid, key, ip, first, last, email, disp, review) VALUES ('".$valid."', '".$key."', '".$ip."', '".$fname."', '".$lname."', '".$email."', '".$disp."', '".$review."')"; mysql_query($q) or die(mysql_error()); ?> Oh, Here is the Database Structure: id post vaild key ip first last email disp review -Thanks Guys! Quote Link to comment https://forums.phpfreaks.com/topic/169242-solved-mysql-error/ Share on other sites More sharing options...
Maq Posted August 7, 2009 Share Posted August 7, 2009 You need backticks around key, it's a reserved word. Quote Link to comment https://forums.phpfreaks.com/topic/169242-solved-mysql-error/#findComment-893038 Share on other sites More sharing options...
Lamez Posted August 7, 2009 Author Share Posted August 7, 2009 Awesome, that did the trick! -Thanks Quote Link to comment https://forums.phpfreaks.com/topic/169242-solved-mysql-error/#findComment-893045 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.