COUNT similar records

[RON_ron]

my mysql has got a field called statez where it stores the STATE. How do I amend the code below by adding $SomeVar = $_POST['Hamburg']; to count the number of records of a particular state? ($SomeVar will represent the state)

 

$query = "SELECT statez, COUNT(statez)FROM distributors GROUP BY statez"; 	 
$results = mysql_query($query);
$returnS="";
while($line = mysql_fetch_array($results))
{
$returnS.= $line['COUNT(statez)'].",,".$line['statez'].",,,";
}
echo $returnS;

[trq]

I'm not sure this is what you mean.

 

$state = mysql_real_escape_string($_POST['Hamburg']);
$query = "SELECT statez, COUNT(statez) FROM distributors WHERE statez = '$state'";

[RON_ron]

Perfect! Thanks.