rendered paste body$sqls = "SELECT substring(fanart_artist,1,1) as mychar FROM fanart GROUP BY mychar";if (!($results = mysql_query($sqls)) ){ echo("Database query failed. Please click here and report this error.");}else{ $letters = array(); while ( $row = mysql_fetch_array($results, MYSQL_BOTH) ) { $char = strtoupper($row['mychar']); $letters[$char] = true; } for ( $i = 0; $i < 26; $i++ ) { if ( $i ) { echo ' | '; } if ( isset($letters[chr($i+ord('A'))]) ) { printf('<a href="url....?nav=%s">%s</a>',strtolower(chr($i+ord('A'))),chr($i+ord('A'))); } else { echo chr($i + ord('A')); } }}