[RESOLVED] Glossay a|b|c

[Avihai]

Hi all,

I have a db with two main fields in a table (name and id).
I want to create a list of links a|b|c|d ...
and when the user clicks on a letter he would get all the names starting with this letter, example:

"a" was clicked and the result would be: Annie, Archie, Anton ...

How can I do it?

Thanks,
Avihai

[TheRave]

SQL Queries:SELECT * FROM foobar WHERE name LIKE 'a%';
SELECT * FROM foobar WHERE name LIKE 'b%';
SELECT * FROM foobar WHERE name LIKE 'c%';
etc.

[Avihai]

Thanks alot!!! :-)