RE: [PHP] newbY prob
| From: | Jennifer Goodie | Date: | Wed, 23 Jul 2003 19:44:20 +0000 |
| Subject: | RE: [PHP] newbY prob | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-156510@lists.php.net to get a copy of this message | ||
> ! 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?
Where is $dbqueryshipping1 set? I see $bdquerymeal, but not
$dbqueryshipping1.