note 27475 deleted from function.mysql-num-rows by victor

From: Date: Sat, 07 Dec 2002 09:49:13 +0000
Subject: note 27475 deleted from function.mysql-num-rows by victor
References: 1  Groups: php.notes 
Request: Send a blank email to php-notes+get-40453@lists.php.net to get a copy of this message
$result = mysql_query("SELECT viewed FROM $SQL_TBL_MESSAGES WHERE to = $l_user AND viewed = '' "); $anymsg = mysql_num_rows ($result); That us my select statement but when I go to get the number of rows i recieve the following error Warning: Supplied argument is not a valid MySQL result resource. Can I not use Where with num rows as I need to only see how many rows there are with that criteria help please.

« previous php.notes (#40453) next »