How to fetch a "group by" Query?
| From: | Frédéric Mériot | Date: | Tue, 10 Jul 2001 12:40:30 +0000 |
| Subject: | How to fetch a "group by" Query? | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-57141@lists.php.net to get a copy of this message | ||
Hello (again)
I've got a query which extract titles and categories with a group by on the
categorie. Is there a simple way to display rows like this (without doing a
second query ):
Categorie A
-titi
-toto
-tutu
Categorie B
-bibi
-nini
-fififi
Categorie C
-titi
-toto
-tutu
... etc
With cold fusion (for those who know) I want to do the same as <CFOUTPUT
QUERY="myquery" GROUP="categorie">
Thanks