Update

subman · 03-29-2008, 05:14 PM

Im having trouble updating a table...

The query

PHP Code:


			
$sql = "UPDATE username password email accesslevel FROM users WHERE username = '$user' AND password = '$md5' AND email = '$email' AND accesslevel = '$access' LIMIT 1;";

    $query = mysql_query($sql) or die(mysql_error());

Any ideas?

Salathe · 03-29-2008, 05:17 PM

The column names need to be comma-separated: UPDATE username, password, email, accesslevel ...

subman · 03-29-2008, 05:21 PM

EDIT: Fixed it...
Thanks.