Re: newbY prob
| From: | CPT John W. Holmes | Date: | Wed, 23 Jul 2003 19:56:43 +0000 |
| Subject: | Re: newbY prob | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-156517@lists.php.net to get a copy of this message | ||
From: "Jennifer Goodie" <goodie@apollointeractive.com>
> > ! 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.
Also, once you fix that, $mealcount is going to be an array. You need to
display $mealcount[0] to get the value.
---John Holmes...