How do I count how many times each entry in a column appears?

[emjez15]

MY SQL Syntax: 

 

$sql="SELECT * FROM incidents WHERE incidentcreateddate BETWEEN '$datefrom' AND '$dateto' ORDER BY incidentid ASC" or die("cannot connect server ");

 

I want this entries for the Date Range Specified Above to be :

 

Complainant---Incident Count

MarkGreen--------------3

Jha Ogbac --------------4

Peter Luciano --------- 10

Donald Guerero ------ 20

[kickstart]

Hi

 

Something like this

 

SELECT Complainant, COUNT(incidentid)
FROM incidents
WHERE incidentcreateddate BETWEEN '$datefrom' AND '$dateto'
GROUP BY Complainant

 

All the best

 

Keith