Mysql Query

need some help

[d40sithui]

hey guys,
i have a table with a field named "status". its value range from 0,1,2. 0 symbolizes "new", 1 -> "approved", 2 -> "denied".
now, what i want is to form a single query and count all records where status=0, where status=1, where status=2. any ideas?

[vincevincevince]

SELECT COUNT(*) FROM `table` GROUP BY `status`

Should do it

[d40sithui]

hi,
this returns all rows. what i was looking for is to return the number of rows where status=0, the number of rows where status=1, and the number of rows where status=2

[omoutop]

it like vincevincevince proposed:

$query1 = "SELECT status, COUNT(status) AS counted FROM {table} GROUP BY status ORDER BY status";
$result1 = mysql_query($query1) or die(mysql_error().'<p>'.$query1.'</p>');
while ($myrow1 = mysql_fetch_array($result1))
{
echo "Total Status of ".$myrow1['status']." = ".$myrow1['counted']."<br>";
}

This should give you something like:
Total Status of 0 = 15
Total Status of 1 = 57
Total Status of 2 = 2

[d40sithui]

thanks.
this is perfect