Worqy Posted July 1, 2010 Share Posted July 1, 2010 I have a problem.. I get an error with this SQL statement.. $PassSQL = ("UPDATE admin WHERE Username=Admin SET Password=123415"); $NewPass=mysql_query($PassSQL); I get 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 'WHERE Username=Admin SET Password=123415' at line 1 If I use the code UPDATE admin SET Password=123415"); $NewPass=mysql_query($PassSQL); I don't get any error.. Quote Link to comment Share on other sites More sharing options...
trq Posted July 1, 2010 Share Posted July 1, 2010 $PassSQL = "UPDATE admin SET Password='123415' WHERE Username = 'Admin'"; Quote Link to comment 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.