compsci Posted March 23, 2008 Share Posted March 23, 2008 Hello all, I have been mulling over this for like an hour now and am frustrated. I bet also the solution is very simple. Please help. This is my sql query using PHP: $email = $_GET['email']; $query = sprintf("UPDATE members SET verified = '1' WHERE userName = $email"); mysql_query($query) or die(mysql_error()); I get this 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 'WHERE username='o1g1aedren@googlemail.com'' at line 1 -->Verified is a tiny int - can this be a problem? What is the probelm?? The above is a simple email activation of an account. Thanks Quote Link to comment https://forums.phpfreaks.com/topic/97523-sql-syntax-error/ Share on other sites More sharing options...
compsci Posted March 23, 2008 Author Share Posted March 23, 2008 [RESOLVED] I was mistakingly pointing to a completley different script! Mods please remove if need be. Quote Link to comment https://forums.phpfreaks.com/topic/97523-sql-syntax-error/#findComment-498993 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.