How do you sort PHP/MySQL results by letter?

Trying to pull data from a database and display it alphabetically by the first letter for each letter on a seperate page.

So like this: # | A | B | C | D ... and when they click on the desired letter it takes them to a page with results. So say I click on "A" I want it to display only results that start with the letter "A" in alphabetical order.

How do pull results by the first letter is basically what I'm asking?
Thanks very much Nithya;)
 
Back
Top