Browse By Letter (a php question)

I am working on a project where I would like to have a menu to search
by Letters.

For instance:

A | B | C | D |E ....

and so on...

However I only want to show the letters that correspond to a product
on the database.

So if I have product:

Apple, and Banana

I would show the letters: A | B

As of right now, I do it in a really bad way.. I have a loop that goes
from A->Z which SELECT COUNTS each letter and throws everything in one
array.

What's a better way to do that? Instead of have 26 queries?

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---