Harmeet,

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.)

Good luck,
Bob

-----Original Message-----
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
news:[EMAIL PROTECTED]
> Hi,
>
> 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
in
> my "members" table but still doesn't produce any results.
>
> Any help is much appreciated.
>
> Harmeet

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to