'on','so'=>'on','gb'=>'on','ssc'=>'on','exec_committee'=>'on',
'ex_officio'=>'on','staff'=>'on','agency_contact'=>'on');
$tbname = TABLE_PERSONNEL;
if(isset($_GET['s'])){
$data = $_GET;
if($data['s'] == "*" || $data['s'] == ""){
$data['s'] = "%";
}
$suf1 = '';
$suf2 = '';
$terms=preg_split ("/(\s+|\+)/", $data['s']);
$num=count($terms);
$tmp = array_intersect_assoc($cat,$data); // Search limiting
for($i=0;$i<$num;$i++){
$term = addslashes($terms[$i]);
$suf1.="last_name LIKE '%$term%' OR first_name LIKE '%$term%' OR institute LIKE '%$term%' OR ";
}
// compile search limiting terms
foreach($tmp as $key => $value){
$suf2 .= $key . "='Y' OR ";
}
$suf1=substr($suf1,0,-4); // chop last ' OR ' off
$suf2=substr($suf2,0,-4); // chop last ' OR ' off
if(empty($suf2)) // No-limit seacrch
$query1="SELECT * FROM $tbname WHERE (" . $suf1 . ") ORDER BY last_name";
else // Limited Search
$query1="SELECT * FROM $tbname WHERE (" . $suf1 . ") AND (" . $suf2 . ") ORDER BY last_name";
} // if(!empty($_GET[s])){
if(!empty($query1)){
echo '
View All' . "\n";
$result=$db->sql_query($query1);
if(!$db->sql_numrows($result)){
echo '
Sorry, there are no results for your query.
' . "\n";
}
else{
echo "
\n";
// Get all the First letters of last names
for($i=0;$row=$db->sql_fetchrow($result);$i++){
$names[$i] = strtoupper(substr($row[last_name],0,1));
$info[$i] = $row;
}
echo display_index($names);
$anchor="";
$info = array_reverse($info);
while( $row=array_pop($info) ){
if( ($a=strtoupper(substr($row[last_name],0,1))) != $anchor){
$anchor=$a;
echo "\n" . '' . "\n";
//echo $i;
}
echo '' . "\n";
if(!empty($row[position])){
echo '' . $row['last_name'] . ', ' . $row['first_name'] . ' (' . $row['position'] . ")
\n";
}
else{
echo '' . $row['last_name'] . ', ' . $row['first_name'] . "
\n";
}
echo $row['institute'] . "
\n";
echo $row['phone'] . "
\n";
if(!empty($row[fax])){
echo $row[fax] . " (fax)
\n";
}
echo '' . $row['email'] . "\n";
echo "
\n";
}
} // else
} // if(!empty($query1))
/*
$i = '
A | B | C | D | E |
F | G | H | I | J |
K | L | M | N | O |
P | Q | R | S | T |
U | V | W | X | Y |
Z
';
echo $i;
*/
else{
$query="SELECT last_name,first_name,position,institute,phone,fax,email FROM $tbname ORDER BY last_name";
$result=$db->sql_query($query);
echo "
\n";
// Get all the First letters of last names
for($i=0;$row=$db->sql_fetchrow($result);$i++){
$names[$i] = strtoupper(substr($row[last_name],0,1));
$info[$i] = $row;
}
echo display_index($names);
$anchor="";
$info = array_reverse($info);
while( $row=array_pop($info) ){
if( ($a=strtoupper(substr($row[last_name],0,1))) != $anchor){
$anchor=$a;
echo "\n" . '' . "\n";
//echo $i;
}
echo '' . "\n";
if(!empty($row[position])){
echo '' . $row['last_name'] . ', ' . $row['first_name'] . ' (' . $row['position'] . ")
\n";
}
else{
echo '' . $row['last_name'] . ', ' . $row['first_name'] . "
\n";
}
echo $row['institute'] . "
\n";
echo $row['phone'] . "
\n";
if(!empty($row[fax])){
echo $row[fax] . " (fax)
\n";
}
echo '' . $row['email'] . "\n";
echo "
\n";
}
} // else
include FOOT;
?>