select error message?

[safra]

hi,

I am trying to find a match in column 'email' (which is set to a tinytext column with null set to 'no') for $email in table 'clientData'.

this is the code I am using in php:

$result = mysql_query("SELECT * FROM clientData WHERE email=$email",$db);

$myrow = mysql_fetch_array($result);

I get the error message:
Warning: Supplied argument is not a valid MySQL result resource

what does this mean?

if the same code is used but on column 'id' it works fine!

Hope anyone can explain to me what I am doing wrong,

thanks,
Ron

 

[devnull22]

b/c email is text, thus you must put $email in single quotes. ie.
WHERE email='$email' ...

cheers devnull22

http://www.kbcenter.com

(Knowledge Base Center )

http://www.clickEval.com

--
Apparently if you play the Windows NT CD backwards you hear satanic messages. If you think that's bad, play it forwards and it installs Windows NT !

 

[safra]

Thanks devnull22!

that worked

Ron