Sorry, there are no results for your query.
' . "\n";
}
while($row=mysql_fetch_assoc($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;
*/
$query="SELECT last_name,first_name,position,institute,phone,fax,email FROM personnel ORDER BY last_name";
$result=mysql_query($query);
$index="";
echo '
';
$j=65;
$nav="";
for($i=0;$row=mysql_fetch_assoc($result);$i++){
$names[$i] = strtoupper(substr($row[last_name],0,1));
$info[$i] = $row;
}
for($i=0;$i' . $a . ' | ';
$index=$a;
$j++;
//$i++;
}
if( $a != chr($j) && $a != $index){
//$j++;
$d=chr($j);
$nav .= $d . ' | ';
$j++;
}
if($a == $index){
$i++;
}
if($j == 91) break;
}
while($j < 90){
$d=chr($j);
$nav .= $d . ' | ';
$j++;
}
$nav .= chr(90);
echo $nav;
$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_nam'] . ' (' . $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";
}
?>
Last updated: 6 April, 2004
Please address any comments or questions to:
U.S. GLOBEC Webmaster
|
