query("SELECT * FROM user_table WHERE authorizationrights = 'GRANTED' ")) { while ($row = $result->fetch_assoc() ) { $stss=$stss. ""; } } $connect->close(); ?> Ntihc

Tollfree callers by times of call

24 THEN 'Over 24' END AS age_range,COUNT(RECORDCOUNTER) FROM tollfree GROUP BY PHONECONTACT,FIRSTNAME DESC"; $res = $conn->query($sql); $x=1; $bal = 0; while($row=$res->fetch_assoc()){ $bal=($bal+ intval($row['RECORDCOUNTER']))-intval($row['RECORDCOUNTER']); echo''. ''. ''. ''. ''. ''. ''. ''. ''. ''. ''. ''. ''. ''. ''; $x=$x+1; } ?>
C/No. Date of first register Caller No. Caller Name School Age Age-group Sex District Marital status Employment status Source of info Times
C/No. Date of first register Caller No. Caller Name School Age Age-group Sex District Marital status Employment status Source of info Times
'.$x.''.$row['DATECREATED'].''.$row['PHONECONTACT'].''.$row['FIRSTNAME'].''.$row['SCHOOLINGSTATUS'].''.$row['AGE'].''.$row['age_range'].''.$row['SEX'].''.$row['DISTRICT'].''.$row['MARITALSTATUS'].''.$row['EMPLOYMENTSTATUS'].''.$row['HEAREDABOUTNTIHC'].''.$row['COUNT(RECORDCOUNTER)'].'