Query Help

[tuf-web_co_uk]

i am currently building an automated menu for a cheat section in my website, i have a code which should display only 1 record of the first letter

$sql = "SELECT DISTINCT letter FROM cheats";
$result = mysql_query($sql);  

if (!$result) {    

echo("<P>Error performing query: " .
mysql_error() . "</P>");    

exit();  }


  while ( $row = mysql_fetch_array($result) ) { 
  echo "<font size=1 face=verdana><b> [<a href=design.php?page=cheats&letter=".$row["letter"].">".$row["letter"]."</a>] </b></font>";
 }

the code, when viewed in internet explorer only shows a zero (0), instead of showing #,A,B,C etc.

could anyone please show me how to do this correctly

thanks alot

[The_Wolf]

Unsure what your trying to do... :/

[tuf-web_co_uk]

i want to create a menu (#, A, B, C) the alphabet, so that people who visit my site can select which letter of cheats they want to view, i want to do this using a database.

i have another menu which is similar to this
it shows sub-sections of a section from records in a database.

so if i had information like

• 1, Misc, Pic1

• 2, Misc, Pic2

• 3, Games, Pic3

• 4, Games, Pic4

instead of showing misc, misc, games, games, on the page where the menu is, it would only show 1 of each (SELECT Distinct type etc)

i know it would be easier to do this by writing out all the links

does that help?!