"Phillip Blancher" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Problem with Count.
! am trying to count the number of items in this table. The table has one
field in it.
The code I am using is:
$dbquerymeal = "select COUNT(*) from mealtype";
$resultmeal = mysql_db_query($dbname,$dbqueryshipping1);
if(mysql_error()!=""){echo mysql_error();}
$mealcount = mysql_fetch_row($resultmeal);
echo $mealcount;
The result I am getting is:
Query was empty
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result
resource in search.php
Any suggestions?
---------------------------------------------------------------------
Looks like you're not passing the correct variable to the second parameter
in mysql_db_query().
- Kevin
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
