[SOLVED] Mysql return issue

[frist44]

I know this is probably rediculous. I've been working with a database all day for some pages and it's been fine. I'm now trying to write some command line scripts to report via email and every mysql_num_rows is returning "1"?

 

mysql_connect($host,$user,$password) or die("Unable to connect to database server");
@mysql_select_db($database) or die("Unable to select database");


$query3="SELECT COUNT(*) FROM $table";

$result=mysql_query($query3);
echo mysql_num_rows($result);

mysql_close();

[revraz]

Because you are only grabbing a COUNT and not actually grabbing any rows.

[trq]

Because a 'SELECT COUNT() query only returns one row. You likely want somthing like....

 

mysql_connect($host,$user,$password) or die("Unable to connect to database server");
@mysql_select_db($database) or die("Unable to select database");

$query3 = "SELECT COUNT(*) FROM $table";

if ($result=mysql_query($query3)) {
  echo mysql_result($result,0);
}

?>

[frist44]

very true. It's been a long day...

 

Thanks!