}
else if ($_GET['action'] == 'search')
{
$Last = $_GET['Last'];
if ($Last == 'Any') { $Last = '%'; }
$Teacher = $_GET['Teacher'];
if ($Teacher == 'Any') { $Teacher = '%'; }
$Mon = $_GET['Mon'];
if ($Mon == 'Any') { $Mon = '%'; }
$Tues = $_GET['Tues'];
if ($Tues == 'Any') { $Tues = '%'; }
$Wed = $_GET['Wed'];
if ($Wed == 'Any') { $Wed = '%'; }
$Thurs = $_GET['Thurs'];
if ($Thurs == 'Any') { $Thurs = '%'; }
$Fri = $_GET['Fri'];
if ($Fri == 'Any') { $Fri = '%'; }
// if ($Teacher == 'Any' || !isset($_GET['Teacher'])) { $Teacher = '%%'; }
if (!isset($_GET['numpage']))
{
$numpage = 1;
}
else
{
$numpage = $_GET['numpage'];
}
$rowlimit = 35;
$offset = $rowlimit * ($numpage - 1);
// $sql = "FROM ASAP WHERE Teacher LIKE '$Teacher%'";
$sql = "FROM ASAP WHERE Teacher LIKE '$Teacher%' AND Last LIKE '$Last%' AND Mon LIKE '$Mon%' AND Tues LIKE '$Tues%' AND Wed LIKE '$Wed%' AND Thurs LIKE '$Thurs%' AND Fri LIKE '$Fri%'";
$sql_query = "SELECT * $sql ORDER BY Last ASC LIMIT $offset, $rowlimit";
$query = mysql_query("$sql_query");
$sql_querycount = "SELECT COUNT(id) $sql";
$querycount = mysql_query("$sql_querycount");
$rowsforpages = mysql_fetch_array($querycount);
$rowsforpages = $rowsforpages['0'];
if ($rowsforpages > 0)
{
?>