----- Original Message -----
From: boclair <[EMAIL PROTECTED]>
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
                 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

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to