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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
