![](../../assets/img/logsbig.PNG)
NUMBER OF CLIENTS WITH STI's BETWEEN AND
Number of STI's
STI CATEGORY |
FEMALES |
MALES |
TOTAL |
10-14 |
15-19 |
20-24 |
Above 24 |
TOTAL |
prepare("SELECT DATECREATED,MEDICALPROBLEM,
sum( if( SEX = 'FEMALE', RECORDCOUNTER, 0 ) ) AS FEMALE,
sum( if( SEX = 'MALE', RECORDCOUNTER, 0 ) ) AS MALE,
sum( if( AGE_GROUP = '10-14', RECORDCOUNTER, 0 ) ) AS gpone,
sum( if( AGE_GROUP = '15-19', RECORDCOUNTER, 0 ) ) AS gptwo,
sum( if( AGE_GROUP = '20-24', RECORDCOUNTER, 0 ) ) AS gpthree,
sum( if( AGE_GROUP = '20-24', RECORDCOUNTER, 0 ) ) AS gpfour
FROM clientsexamination
WHERE DATECREATED BETWEEN :a AND :b AND MEDICALTOPIC='STI' GROUP BY MEDICALPROBLEM ASC ");
$result->bindParam(':a', $d1);
$result->bindParam(':b', $d2);
$result->execute();
for($i=0; $row = $result->fetch(); $i++){
?>
|
|
|
|
|
|
|
|
|
TOTAL: |
prepare("SELECT sum(RECORDCOUNTER) FROM clientsexamination WHERE SEX = 'FEMALE' AND DATECREATED BETWEEN :a AND :b AND MEDICALTOPIC='STI'");
$results->bindParam(':a', $d1);
$results->bindParam(':b', $d2);
$results->execute();
for($i=0; $rows = $results->fetch(); $i++){
$dsdsd=$rows['sum(RECORDCOUNTER)'];
echo formatMoney($dsdsd, true);
}
?>
|
prepare("SELECT sum(RECORDCOUNTER) FROM clientsexamination WHERE SEX = 'MALE' AND DATECREATED BETWEEN :c AND :d AND MEDICALTOPIC='STI'");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(RECORDCOUNTER)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(RECORDCOUNTER) FROM clientsexamination WHERE DATECREATED BETWEEN :c AND :d AND MEDICALTOPIC='STI'");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(RECORDCOUNTER)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(RECORDCOUNTER) FROM clientsexamination WHERE AGE_GROUP = '10-14' AND DATECREATED BETWEEN :c AND :d AND MEDICALTOPIC='STI'");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(RECORDCOUNTER)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(RECORDCOUNTER) FROM clientsexamination WHERE AGE_GROUP = '15-19' AND DATECREATED BETWEEN :c AND :d AND MEDICALTOPIC='STI'");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(RECORDCOUNTER)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(RECORDCOUNTER) FROM clientsexamination WHERE AGE_GROUP = '20-24' AND DATECREATED BETWEEN :c AND :d AND MEDICALTOPIC='STI'");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(RECORDCOUNTER)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(RECORDCOUNTER) FROM clientsexamination WHERE AGE_GROUP = '24' AND DATECREATED BETWEEN :c AND :d AND MEDICALTOPIC='STI'");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(RECORDCOUNTER)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(RECORDCOUNTER) FROM clientsexamination WHERE DATECREATED BETWEEN :c AND :d AND MEDICALTOPIC='STI'");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(RECORDCOUNTER)'];
echo formatMoney($zxc, true);
}
?>
|