Forum Moderators: coopster
Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/bloomers/public_html/count.php on line 17
<?$dbhost = "localhost";
$dbuser = "bloomers";
$dbpass = "*****";
$dbname = "bloomers_portal";
$table = "messages";
$no = "no";
mysql_connect($dbhost,$dbuser,$dbpass) or die ("Unable to connect to database");
@mysql_select_db("$dbname") or die ("Unable to retrieve news from database");
$sqlquery = "SELECT * FROM messages WHERE read ='$no' AND recipient = '$customerid'";
$result = mysql_query($sqlquery);
$number = mysql_numrows($result);
$i = 0;
if ($number <1)
{
echo "<center><a href=inbox.php>You have no messages in your inbox.</font></center>";
}
else {
while ($number > $i)
{
echo " <a href=inbox.php>You have $number new messages.</font>";
$i++;
}
}
?>
$result = mysql_query($sqlquery);
isn't executing correctly meaning that there's a problem with your query somewhere.
Just a wild guess here, but is recipient an integer of some sort? then it shouldn't be enclosed in single quotes.
mavherick
