TalkPHP - View Single Post

subman · 03-29-2008, 04: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?

03-29-2008, 04:14 PM	#1 (permalink)
subman The Wanderer Join Date: Mar 2008 Posts: 7 Thanks: 2	Update 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?