RE: [PHP] How to fetch a "group by" Query?

this is the sort of thing I usually do ... $result = mysql_query($db, "SELECT * FROM filename...") while ($array = mysql_fetch_array($result)) $category[$array["category"]][] = $array["title"]; foreach ($category as $cat=>$title_array) { echo("Category $cat<br>"); foreach ($title_array as $title) echo(" - $title<br>"); } a lot simpler and you don't have to worry about any start and end conditions. This can also be extrapolated to more complex situations, e.g. where $title contains more than just a name you can do sub totals of "title" quantities by category, or whatever. Tim Ward Senior Systems Engineer Please refer to the following disclaimer in respect of this message: http://www.stivesdirect.com/e-mail-disclaimer.html > -----Original Message----- > From: David Robley [mailto:huntsman@www.nisu.flinders.edu.au] > Sent: 11 July 2001 02:17 > To: Frédéric Mériot; PHP General List > Subject: Re: [PHP] How to fetch a "group by" Query? > > > On Tue, 10 Jul 2001 22:10, Frédéric Mériot wrote: > > 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 > > Select category, description from table where whatever order > by category, > description > > Then when you display the rows, keep track of the current and > previous > value of $description; if it changes, print the new value. > > -- > David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc > CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA > > Don't stop posting, a good laugh breaks up my day nicely >