> 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

Yikes!  I hope those are typos, and that you didn't cut and paste that query
from your script.  If you did, then it needs some work.  Try:

$deceased = mysql_query("SELECT * FROM members where status='deceased'");

You need the leading double quote before SELECT, and you don't need to
escape the single quotes.


- Darryl

 ----------------------------------------------------------------------
  Darryl Friesen, B.Sc., Programmer/Analyst    [EMAIL PROTECTED]
  Education & Research Technology Services,     http://gollum.usask.ca/
  Department of Computing Services,
  University of Saskatchewan
 ----------------------------------------------------------------------
  "Go not to the Elves for counsel, for they will say both no and yes"



-- 
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