[Resolved] Problem with mySQL COUNT

[ow-phil]

I 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 suggestion?

[stolzyboy]

you could just do this if you want

<?
$query = "select * from mealtype;";
$result = mysql_query($query) or die(mysql_error());

echo mysql_num_rows($result);
?>

[kevinsequeira]

$dbquerymeal = "select COUNT(*) from mealtype";
$resultmeal = mysql_db_query($dbname,$dbqueryshipping1); if(mysql_error()!=""){echo mysql_error();}
$mealcount = mysql_fetch_row($resultmeal);
echo $mealcount;

you've called your query $dbquerymeal, but passing it as dbqueryshipping1 in the mysql_db_query() function.

also you need to do echo $mealcount[0];

reg
kevin