[RESOLVED] A to Z index page

[mikawhat]

I'm trying to create an A to Z index page and i'd like to know how to make the query search for words starting with a letter. I want something like [A] [C]....[X] [Y] [Z] and when the user clicks a letter all the words starting with that letter should be displayed.

[bradgrafelman]

SELECT name, description, whatever FROM myTable WHERE name LIKE 'A%'

[Weedpacket]

http://www.phpbuilder.com/board/showthread.php?t=10262686&highlight=alphabetical+index
http://www.phpbuilder.com/board/showthread.php?t=10209797&highlight=alphabetical+index

[mikawhat]

ok. thanx a lot guys!