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?
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.501 / Virus Database: 299 - Release Date: 7/14/2003
