newbY prob
| From: | Phillip Blancher | Date: | Wed, 23 Jul 2003 19:38:04 +0000 |
| Subject: | newbY prob | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-156509@lists.php.net to get a copy of this message | ||
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