Help with MySQL statement....

[Worqy]

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..

 

 

[trq]

$PassSQL = "UPDATE admin SET Password='123415' WHERE Username = 'Admin'";