Dotnetindex.com

Counting records in PHP mySQL

Following code samples, demonstrates how to count records in a MySQL database table. You may send parameters to query to display only selected range of rows.

mysql_pconnect($server, $username, $password);
mysql_select_db("articles_index") or die("Can not find database");

$query = "select * from articles where catID = 4";
$result = mysql_query($query);

while ($row = mysql_fetch_array($result))
{
$count = $row["count"];
}
echo $count;

?>