<?php
$hostname = "localhost";
$database = "adddbname";
$username = "adddbusername";
$password = "addpassword";
$connection1 = mysql_pconnect($hostname, $username, $password) or trigger_error(mysql_error(),E_USER_ERROR);
$table = "oanfc_k2_items";
//Data Extraction

mysql_select_db($database, $connection1);

$query = "SELECT DISTINCT UPPER(LEFT(title,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="index.php?option=com_k2&view=itemlist&layout=category&ltr="'.$letter.'" rel="nofollow">"'.$letter.'"</a> | ';
}

; ?>