kinsesyete
Posts: 9
|
| Posted: 01/21/2011, 4:53 AM |
|
I have this FPDF Report codes
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 to be
Complainant---Incident Count
MarkGreen--------------3
Jha Ogbac --------------4
Peter Luciano --------- 10
Donald Guerero ------ 20
|
 |
 |
Waspman
Posts: 948
|
| Posted: 01/21/2011, 8:02 AM |
|
Report builder?
_________________
http://www.waspmedia.co.uk |
|
|
|
damian
Posts: 838
|
| Posted: 01/21/2011, 9:41 PM |
|
SELECT DISTINCT range_name, count( range_name ) AS count
FROM `range`
GROUP BY range_name
_________________
if you found this post useful take the time to help someone else.... :)
|
|
|
|
damian
Posts: 838
|
| Posted: 01/21/2011, 9:43 PM |
|
$sql="SELECT DISTINCT *, count(Complainant)
FROM incidents
WHERE incidentcreateddate BETWEEN '$datefrom' AND '$dateto'
ORDER BY incidentid ASC"
or die("cannot connect server ");
_________________
if you found this post useful take the time to help someone else.... :)
|
|
|
|
