Re: [PHP] Count number of rows in table.

[Bas Jobsen]

> $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