Re: Select where

----- Original Message ----- From: boclair <boclair@bigpond.net.au> To: <php-db@lists.php.net> Sent: Wednesday, March 21, 2001 12:02 AM Subject: [PHP-DB] Select where > This is simple but I cannot see where I am going wrong > > I have a table members with one of the fields > status, varchar(10) > > The values may be active or retired or deceased or null > > If I run the select > > SELECT * FROM members WHERE status = 'deceased'; > > I get MySQL said: You have an error in your SQL syntax near > '\'deceased\';' at line 1 > > Will somebody show me the correct syntax _______________________ > $query = "SELECT * FROM members where status='deceased'" > > Then just call the $query in your script _______________________________ Thanks, I only gave the mySQL but the php scripting is $deceased = mysql_query(SELECT * FROM members where status=\'deceased\'"); and later while ($myrow = mysql_fetch_row($deceased)) MySQL now says in relation to the *while* line Warning: Supplied argument is not a valid MySQL result resource Tim Morris