Help count database using php... urgent 10 points?
heres my table
id equipment
1 a
2 b
3 c
4 a

the output will be
a = 2
b = 1
c = 1
i want to put them in to array... heres my code that only read a.
$result2 = mysql_query("SELECT count(*) FROM workorder WHERE equipment LIKE '$equip' AND equipment =a' AND startact BETWEEN '$from' AND '$to'");

$rrra=$row[0];

echo="a".$rrra;

how to add more count to read? i need code. not explanation please