"") {$sqlquery = "SELECT * FROM $DBTable WHERE (`town` = '$town') and (`ezdraft` = 'no' and `ezpublic` = 'yes') order by $sort ASC";}
elseif ($school <> "") {$sqlquery = "SELECT * FROM $DBTable WHERE (`school` = '$school') and (`ezdraft` = 'no' and `ezpublic` = 'yes') order by $sort ASC";}
elseif ($last <> "") {$sqlquery = "SELECT * FROM $DBTable WHERE (`last` = '$last') and (`ezdraft` = 'no' and `ezpublic` = 'yes') order by $sort ASC";}
elseif ($first <> "") {$sqlquery = "SELECT * FROM $DBTable WHERE (`first` = '$first') and (`ezdraft` = 'no' and `ezpublic` = 'yes') order by $sort ASC";}
else {
if ($UserType == "Admin"||$UserType=="Editor") {$sqlquery = "SELECT * FROM $DBTable order by $sort ASC";}
elseif ($UserType == "User") {$sqlquery = "SELECT * FROM $DBTable WHERE (`ezdraft` = 'no') order by $sort ASC";}
else {$sqlquery = "SELECT * FROM $DBTable WHERE (`ezdraft` = 'no' and `ezpublic` = 'yes') order by $sort ASC";}
}
$result = mysql_query($sqlquery);
$number = mysql_numrows($result);
if ($number > 0) {$sname = mysql_result($result,0,"school");}
else {$sname = $scode;}
?>
There Were No Results for Your Search";
print "$sqlquery";
}
else {
while ($number > $i) {
// Name
//-------------------------
$key = mysql_result($result,$i,"key");
$school = mysql_result($result,$i,"school");
$first = mysql_result($result,$i,"first");
$last = mysql_result($result,$i,"last");
$title = mysql_result($result,$i,"title");
$email = mysql_result($result,$i,"email");
$phone = mysql_result($result,$i,"phone");
$ext = mysql_result($result,$i,"ext");
$room = mysql_result($result,$i,"room");
$web = mysql_result($result,$i,"web");
$comments = mysql_result($result,$i,"comments");
$town = mysql_result($result,$i,"town");
$pdate = mysql_result($result,$i,"pdate");
$ezdraft = mysql_result($result,$i,"ezdraft");
$ezpublic = mysql_result($result,$i,"ezpublic");
if ($i%2) {$bgc = "FFFFFF";}
else {$bgc = "FFFABC";}
if ($key)
{ print "
| $first $last |
$title |
$email |
";
print "
";
}
$i++;
}
}
//-- Close SQL Connection
//----------------------------------------
mysql_free_result( $result );
mysql_close($con);
?>