Driving me nuts! any clues
Posted: Sat May 31, 2008 10:43 pm
I keep getting the smurf error from this simple code
$sql = "update $table_name set usergroup = '$approved' where username = '$username' ";
The error is
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 'set usergroup = 'Users' where username = 'dodo'' at line 1
The only thing I can see in the error message is the different quotes around 'dodo" . The above message is a cut and paste so there are no typos.
Any help greatly appreciated.
Thanks
$sql = "update $table_name set usergroup = '$approved' where username = '$username' ";
The error is
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 'set usergroup = 'Users' where username = 'dodo'' at line 1
The only thing I can see in the error message is the different quotes around 'dodo" . The above message is a cut and paste so there are no typos.
Any help greatly appreciated.
Thanks