MySql Query Error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Sgt Burned
    New Member
    • Mar 2012
    • 2

    MySql Query 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 'id','username' ,'hashedpasswor d','country','c ','SgtBurned' at line 2
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    You need to fix whatever is wrong with your syntax. Since you didn't post your SQL, that's all I can say.

    Comment

    • Sgt Burned
      New Member
      • Mar 2012
      • 2

      #3
      As in an Error in this part
      Code:
      		$sql = mysql_query("INSERT INTO members (id,username, password, country, city, accounttype, email, signupdate) 
      		VALUES('',$username','$hashedPass','$country','$city','$accounttype','$email', now())") or die (mysql_error());
      Or something else?

      Comment

      • Rabbit
        Recognized Expert MVP
        • Jan 2007
        • 12517

        #4
        You're missing a single quote before your user name variable.

        Comment

        Working...