Paul,
It is not an error for $category to be 'no' in all records. The warning is just telling me that it didn't find any 'yes' records.
Well, no, it is not. The error you showed was:
Warning: Supplied argument is not a valid MySQL result resource in {pathname to program} on line 40
PHP is telling you that $res does not refer to a valid result set. That means your query *failed with an error*, not that it executed properly and returned no records.
I need to read up and find out how to error check the SELECT statement, I guess...
Yes. Try this, for example:
if (!$res)
die ("query failed, error message is: " . mysql_error ());
-tom
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
