RE: What's wrong with this QUERY?? - Thanks all.

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: php-db@lists.php.net Subject: Re: What's wrong with this QUERY?? - Thanks all. 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