include("config.ini"); ?>
include("includes/header.inc") ?>
include("includes/search.inc") ?>
if ($submit) {
?>
$whereclause = "verified = '1'";
if ($first) { $whereclause = $whereclause." AND first like '%$first%'"; };
if ($nick) { $whereclause = $whereclause." AND nick like '%$nick%'"; };
if ($last) { $whereclause = $whereclause." AND last like '%$last%'"; };
if ($gradyear) { $whereclause = $whereclause." AND gradyear like '%$gradyear%'"; };
if ($state) { $whereclause = $whereclause." AND state like '%$state%'"; };
$selectresult = mysql_query ("SELECT DISTINCT id,first,nick,last,city,state,listed FROM $table WHERE $whereclause");
print ("
");
if ($row = mysql_fetch_array($selectresult)) {
do {
print ("| $row[first] $row[nick] $row[last] | ");
if($row[listed]){
print ("$row[city],$row[state] | Send Email | ");
} else {
print ("No Public Profile | ");
}
print ("
");
} while($row = mysql_fetch_array($selectresult));
} else {print "| Sorry, no records were found! |
";};
print ("
");
?>
} elseif($letter) {
?>
$selectresult = mysql_query ("SELECT DISTINCT id,first,nick,last,city,state,listed FROM $table WHERE last LIKE '$letter%'");
print ("
");
if ($row = mysql_fetch_array($selectresult)) {
do {
print ("| $row[first] $row[nick] $row[last] | ");
if($row[listed]){
print ("$row[city],$row[state] | Send Email | ");
} else {
print ("No Public Profile | ");
}
print ("
");
} while($row = mysql_fetch_array($selectresult));
} else {print "| Sorry, no records were found! |
";};
print ("
");
?>
}
include("includes/footer.inc");
?>