SELECT SUBSTR(productname, 0, 1), count(*) FROM products GROUP BY SUBSTR(productname, 0, 1) ORDER BY SUBSTR(productname, 0, 1)
If you can create something like that in CakePHP, then you will get each letter, plus the count of poducts. If you don't need the count, just do something like: SELECT DISTINCT SUBSTR(productname, 0, 1) FROM products ORDER BY SUBSTR(productname, 0, 1) Do check that SUBSTR index starts from 0 or one! Enjoy, John On Oct 31, 4:42 am, "[email protected]" <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
