or, you should be able to simply do this, without the cost of fetching the results:
$result = mysql_query("SELECT count(*) FROM table WHERE"); $num_rows = mysql_num_rows($result); echo "$num_rows Rows\n"; >> $sql = "select count(*) from table_name WHERE ....."; >> $result = mysql_query($sql) or die(mysql_error); >> $row = mysql_fetch_row($result); >> $rowCount=$row[0]; > or > $sql = "select count(*) from table_name WHERE ....."; > $result = mysql_query($sql) or die(mysql_error); > $rowCount=mysql_result($result); > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php