_______________________
$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
in that case, you don't need to escape the single ' since you are using double " to enclose your statement, however, you should have got a parse error if that is your code exactly, because you are missing a " at the start of the statement =)
also, make sure that the values in the db are always lower-case to get the match (i *think* it's case-sensitive off the top of my head)
HTH
Beau
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
For additional commands, e-mail: php-db-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net
--
Beau Lebens - Web Master
Insurance My Way, Your Friendly Online Broker
(08) 9226 5888
http://www.insurancemyway.com.au/