MySQL error (driving me bonkers)

[Holymight]

I have the following code on my site

$email = $COOKIE["ck_username"];
$encryptedpassword = $COOKIE["ck_password"];

		$result = mysql_query("SELECT * FROM user_account WHERE email='$email' and password='$encryptedpassword'"); 
	    $row = mysql_fetch_row($result);

Now, when I try to execute this script it gives my the following error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwHolymight\test\current_user.inc on line 51

Any help will be appreciated very very very much.

Jaco Joubert

[cgraz]

I can't remember for sure, but I believe the word 'password' is a reserved name. I'd suggest using mysql_error() to find out what the problem is.

$result = mysql_query("SELECT * FROM user_account WHERE email='$email' and password='$encryptedpassword'") or die(mysql_error()); 

Also in the code you provided, you're using the function mysql_fetch_row(), yet in the error you provided, it says you're using the function mysql_fetch_array()

Cgraz