The field email is obviously a field that can accept strings. In SQL, you must wrap
strings in single-quotes. So, rewrite your query as:
$query = "SELECT id, email, familyname FROM members WHERE email='$thing'";
The reason it worked for id=$thing is that the id field is probably an integer field
and integers do not require quotes.
Remember, wrap your strings in quotes and don't wrap your numbers (unless the number
is really a string in disquise.)
From: Harry G [mailto:harry (removethis)@gabha.net]
Sent: Thursday, July 22, 2004 10:59 PM
To: [EMAIL PROTECTED]
Subject: Re: What's wrong with this QUERY?? - Thanks all.
Thank you everybody.
"Harry G" <[EMAIL PROTECTED]> wrote in message
> I have a database with members details and PK is id.
> $thing = "[EMAIL PROTECTED]";
> $query = "SELECT id, email, familyname FROM members WHERE email=$thing";
> $result = mysql_query($query);
> If i do a query where id=$thing.
> and $thing="20";
> this works fine and I get the desired result. But what is wrong with the
> other one, when I do search for the email address??
> The email address does exist exactly as quoted above in the "email" field
> my "members" table but still doesn't produce any results.
> Any help is much appreciated.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php