| |
|
|
| |
| |
= $total)
$limit=$total;
$scale1 = $limit - $cline;
$qry = $qry." LIMIT $cline,$scale1;";
$result = mysqli_query($connect, $qry,$connect);
?>
| Search Results |
| No Schools Found |
");
} else {
for($s=0;$row = mysqli_fetch_array($result);$s++) {
$mem_qry = mysqli_query($connect, "SELECT COUNT(*) FROM my_school WHERE s_no=$row[s_no]",$connect);
$mem_tot = mysql_result($mem_qry,0,0);
if($row[org] == 'pr') {
$org_txt = "Primary School";
} else if($row[org] == 'inter') {
$org_txt = "Intermediate";
} else if($row[org] == 'col') {
$org_txt = "College";
} else if($row[org] == 'ter') {
$org_txt = "Teriary School";
} else if($row[org] == 'post') {
$org_txt = "Post Graduate";
} else if($row[org] == 'work') {
$org_txt = "Workplace";
} else if($row[org] == 'club') {
$org_txt = "Club";
}
if($row[location]) {
$lo_row = select_qry('local_area','no',$row[location],$connect);
$location_txt = $lo_row['city_name'];
if($lo_row['town_name']) {
$location_txt .= "-".$lo_row['town_name'];
}
}
if(fmod($s,2) == 0 ) {
$bgcolor = "#FFFFFF";
} else {
$bgcolor = "#F5F5F5";
}
?>
|
|
| |
|
|
|
|
|
|
|
|
|
 |
|
