>_______________________
>
> > $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: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
Beau Lebens - Web Master
Insurance My Way, Your Friendly Online Broker
(08) 9226 5888
http://www.insurancemyway.com.au/
--
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]
