Display total records

[erme]

How can I display the total records in an sql database for anything with the same entry for a specific field.

 

Example, I have 300 entries all with a 'County' field of Essex .. I want to display the number 300.

[Andy-H]

$query = "SELECT * FROM Table WHERE County = 'Essex' ORDER BY id DESC";
$result = mysql_query($query)or trigger_error("MySQL Error With Query 1", E_USER_WARNING);
$num = mysql_num_rows($result);


echo "<pre>\tThere are " . number_format($num) . " records in the County 'Essex'.\n</pre>";

 

 

mysql_num_rows

[ChemicalBliss]

Im not stalking you andy i swear .

But you can use a native mysql function to count the number of rows:

SELECT count(*) FROM `table` WHERE `County`='Essex'

 

eg:

<?php

// Connect

$query = "SELECT count(*) FROM `table` WHERE `County`='Essex'";
$result = mysql_query($query) or die(mysql_error());
$number = mysql_result($result,0,0);

echo($number);

?>

 

-CB-

[Andy-H]

Im not stalking you andy i swear .

 

 

lol