'on','so'=>'on','gb'=>'on','exec_committee'=>'on',
'ex_officio'=>'on','staff'=>'on','agency_contact'=>'on');
$tbname = TABLE_PERSONNEL;
if(!empty($_GET['s'])){
$data = $_GET;
$suf1 = '';
$suf2 = '';
$terms = preg_split ("/(\s+|\+)/", $_GET['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 . ") AND scs='Y' ORDER BY last_name";
else // Limited Search
$query1="SELECT * FROM $tbname WHERE (" . $suf1 . ") AND scs='Y' AND (" . $suf2 . ") ORDER BY last_name";
} // if(!empty($_GET[s])){
if(!empty($query1)){
$result=$db->sql_query($query1);
if(!$db->sql_numrows($result)){
echo '
Sorry, there are no results for your query.
' . "\n";
}
while($row=$db->sql_fetchrow($result)){
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";
}
echo "
\n";
}
/*
$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;
*/
$query1 = "SELECT last_name,first_name,position,institute,phone,fax,email,exec_committee FROM $tbname WHERE scs='Y' ORDER BY last_name";
$result1 = $db->sql_query($query1);
$index = '';
echo "
\n";
// Get all the First letters of last names
for($i=0;$row=$db->sql_fetchrow($result1);$i++){
$names_ssc[$i] = strtoupper(substr($row['last_name'],0,1));
$info_ssc[$i] = $row;
}
// Create the SSC A-Z nav bar
$j=65; // ACSII index of capital A
$nav_ssc=""; // variable to compile nav bar
for($i=0;$i' . $a . ' | ';
$index=$a;
$j++;
}
if( $a != chr($j) && $a != $index){
//$j++;
$d=chr($j);
$nav_ssc .= $d . ' | ';
$j++;
}
if($a == $index){
$i++;
}
if($j == 91) break;
}
// fill remaining letters to Z
while($j < 91){
$d=chr($j);
$nav_ssc .= $d . ' | ';
$j++;
}
//$nav_ssc .= chr(90);
$nav_ssc = substr($nav_ssc, 0, -3); //
echo "Standing Committee for Synthesis Members
\n";
echo $nav_ssc;
$anchor="";
$info_ssc = array_reverse($info_ssc);
while( $row=array_pop($info_ssc) ){
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";
}
include FOOT;
?>