 |
 |
 Sorry, there are no results for your query."; } while($row=mysql_fetch_assoc($result)){ echo " ";
echo "$row[last_name], $row[first_name]
"; } $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 * FROM personnel ORDER BY last_name"; $result=mysql_query($query); $anchor=""; while($row=mysql_fetch_assoc($result)){ if( ($a=strtolower(substr($row[last_name],0,1))) != $anchor){ $anchor=$a; echo ""; //echo $i; } echo " ";
echo "$row[last_name], $row[first_name]
|