| |
|
|
| |
| |
= $_REQUEST[year_f] OR my_school.year_t >= $_REQUEST[year_f]) AND (my_school.year_f <= $_REQUEST[year_t] OR my_school.year_t <= $_REQUEST[year_t]))";
} else if($_REQUEST[year_f]) {
$qry .= " AND (my_school.year_f >= $_REQUEST[year_f] OR my_school.year_t >= $_REQUEST[year_f])";
} else if($_REQUEST[year_t]) {
$qry .= " AND (my_school.year_f <= $_REQUEST[year_t] OR my_school.year_t <= $_REQUEST[year_t])";
}
if($_REQUEST[age_f] && $_REQUEST[age_t]) {
$from = date("Y") - $_REQUEST[age_f];
$from_date = $from."1231";
$to = date("Y") - $_REQUEST[age_t];
$to_date = $to."0101";
$qry .= " AND (member.dob BETWEEN $to_date AND $from_date)";
} else if($_REQUEST[age_f]) {
$from = (date("Y") - $_REQUEST[age_f]) + 1;
$from_date = $from."0101";
$qry .= " AND (member.dob < $from_date)";
} else if($_REQUEST[age_t]) {
$to = date("Y") - $_REQUEST[age_t];
$to_date = $to."0101";
$qry .= " AND (member.dob >= $to_date)";
}
if($_REQUEST[user_name]) {
$formatted_name = strtoupper($_REQUEST[user_name]);
$name_array = explode(" ",$formatted_name);
$qry .= " AND ( ";
for($na=0;$na= $total)
$limit=$total;
$scale1 = $limit - $cline;
$qry = $qry." LIMIT $cline,$scale1;";
$result = mysqli_query($connect, $qry,$connect);
?>
|
|
|
|
 |
|
