A-Z Index

$query = "SELECT DISTINCT UPPER(LEFT(LNAME,1)) as letters FROM $table ORDER BY letters";
 
if ($result = mysql_query($query)) {
  while ($row = mysql_fetch_array($result)) {
    $letter_string .= $row["letters"];
  }
}
 
$letter_array = range('A','Z');
 
foreach ($letter_array as $letter) { 
  if (stristr($letter_string, $letter) === FALSE) echo $letter . " | ";
  else echo "<a href='list.php?ltr=".$letter."'>".$letter."</a> | ";
}