Re: What's wrong with this QUERY?? - Thanks all.
| From: | Harry G | Date: | Fri, 23 Jul 2004 03:58:47 +0000 |
| Subject: | Re: What's wrong with this QUERY?? - Thanks all. | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-35441@lists.php.net to get a copy of this message | ||
Thank you everybody.
"Harry G" <harry@gabha.net> wrote in message
news:20040723025938.59488.qmail@pb1.pair.com...
> Hi,
>
> I have a database with members details and PK is id.
>
> $thing = "July22@gabha.net";
>
> $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