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
