By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,641 Members | 2,085 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,641 IT Pros & Developers. It's quick & easy.

MySql Query Error

P: 2
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 'id','username','hashedpassword','country','c','Sg tBurned' at line 2
Mar 28 '12 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,365
You need to fix whatever is wrong with your syntax. Since you didn't post your SQL, that's all I can say.
Mar 28 '12 #2

P: 2
As in an Error in this part
Expand|Select|Wrap|Line Numbers
  1.         $sql = mysql_query("INSERT INTO members (id,username, password, country, city, accounttype, email, signupdate) 
  2.         VALUES('',$username','$hashedPass','$country','$city','$accounttype','$email', now())") or die (mysql_error());
  3.  
Or something else?
Mar 28 '12 #3

Rabbit
Expert Mod 10K+
P: 12,365
You're missing a single quote before your user name variable.
Mar 28 '12 #4

Post your reply

Sign in to post your reply or Sign up for a free account.