DAILY ART TEMPLATE BETWEEN AND
| ART ENROLLMENT |
TOTAL POSITIVE |
MALES 10 - 14 |
FEMALES 10 - 14 |
MALES 15 - 19 |
FEMALES 15 - 19 |
MALES 20 - 24 |
FEMALES 20 - 24 |
MALES > = 24 |
FEMALES > = 24 |
IN SCHOOL +VE |
OUT SCHOOL +VE |
prepare("SELECT DATECREATED,
SUM(RECORDCOUNTER) AS tot,
sum( if( AGE_GROUP = '10-14' AND SEX='MALE', RECORDCOUNTER, 0 ) ) AS mone,
sum( if( AGE_GROUP = '10-14' AND SEX='FEMALE', RECORDCOUNTER, 0 ) ) AS fone,
sum( if( AGE_GROUP = '15-19' AND SEX='MALE', RECORDCOUNTER, 0 ) ) AS mtwo,
sum( if( AGE_GROUP = '15-19' AND SEX='FEMALE', RECORDCOUNTER, 0 ) ) AS ftwo,
sum( if( AGE_GROUP = '20-24' AND SEX='MALE', RECORDCOUNTER, 0 ) ) AS mthree,
sum( if( AGE_GROUP = '20-24' AND SEX='FEMALE', RECORDCOUNTER, 0 ) ) AS fthree,
sum( if( AGE_GROUP = '24' AND SEX='MALE', RECORDCOUNTER, 0 ) ) AS mfour,
sum( if( AGE_GROUP = '24' AND SEX='FEMALE', RECORDCOUNTER, 0 ) ) AS ffour,
sum( if( SCHOOLING = 'IS', RECORDCOUNTER, 0 ) ) AS insc,
sum( if( SCHOOLING = 'OS', RECORDCOUNTER, 0 ) ) AS ossc
FROM artmgr
WHERE DATECREATED BETWEEN :a AND :b GROUP BY DATECREATED ASC ");
$result->bindParam(':a', $d1);
$result->bindParam(':b', $d2);
$result->execute();
for($i=0; $row = $result->fetch(); $i++){
?>
|
|
|
|
|
|
|
|
|
|
|
|
| TOTAL |
prepare("SELECT sum(RECORDCOUNTER) FROM artmgr WHERE DATECREATED BETWEEN :a AND :b");
$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 artmgr WHERE AGE_GROUP = '10-14' AND SEX='MALE'
AND DATECREATED BETWEEN :c AND :d ");
$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 artmgr WHERE AGE_GROUP = '10-14' AND SEX='FEMALE' AND DATECREATED BETWEEN :c AND :d ");
$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 artmgr WHERE AGE_GROUP = '15-19' AND SEX='MALE' AND DATECREATED BETWEEN :c AND :d");
$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 artmgr WHERE AGE_GROUP = '15-19' AND SEX='FEMALE' AND DATECREATED BETWEEN :c AND :d");
$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 artmgr WHERE AGE_GROUP = '20-24' AND SEX='MALE' AND DATECREATED BETWEEN :c AND :d");
$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 artmgr WHERE AGE_GROUP = '20-24' AND SEX='FEMALE' AND DATECREATED BETWEEN :c AND :d");
$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 artmgr WHERE AGE_GROUP = '24' AND SEX='MALE' AND DATECREATED BETWEEN :c AND :d");
$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 artmgr WHERE AGE_GROUP = '24' AND SEX='FEMALE' AND DATECREATED BETWEEN :c AND :d");
$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 artmgr WHERE SCHOOLING = 'IS' AND DATECREATED BETWEEN :c AND :d");
$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 artmgr WHERE SCHOOLING = 'OS' AND DATECREATED BETWEEN :c AND :d");
$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);
}
?>
|