Eugene Posted April 27, 2006 Share Posted April 27, 2006 [!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]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 'desc, cat, banurl, id) VALUES('ggg', 'ggg', '[email protected]',[/quote]Code that triggers that is here:[code]if(validate_email($email)){ mysql_query(" INSERT INTO top (username, password, email, url, title, desc, cat, banurl, id) VALUES('$username', '$password', '$email', '$url', '$title', '$desc', '$catergory', '$banner', '$sql') ") or die(mysql_error()); echo "Congratulations, you are now a registered member"; } [/code]The Variables are here:[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]$username = $_POST['username'];$password = $_POST['password'];$confirm = $_POST['confpass'];$email = $_POST['email'];$url = $_POST['url'];$title = $_POST['title'];$desc = $_POST['description'];$catergory = $_POST['cat'];$banner = $_POST['banurl'];$submit = $_POST['submit'];[/quote] Link to comment https://forums.phpfreaks.com/topic/8585-weird-error/ Share on other sites More sharing options...
kenrbnsn Posted April 27, 2006 Share Posted April 27, 2006 The word "desc" is a reserved word, surround it with back ticks ( [!--coloro:#FF0000--][span style=\"color:#FF0000\"][!--/coloro--][b]`[/b][!--colorc--][/span][!--/colorc--] )[code]<?phpmysql_query(" INSERT INTO top (`username`, `password`, `email`, `url`, `title`, `desc`, `cat`, `banurl`, `id`) VALUES('$username', '$password', '$email', '$url', '$title', '$desc', '$catergory', '$banner', '$sql') ") or die(mysql_error()); ?>[/code]Ken Link to comment https://forums.phpfreaks.com/topic/8585-weird-error/#findComment-31491 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.