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! 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. 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 Link to comment https://forums.phpfreaks.com/topic/169242-solved-mysql-error/#findComment-893045 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.