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

2001-07-11 Thread Chris Lambert - WhiteCrown Networks
crown.net */ - Original Message - From: Tim Ward <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; Frédéric Mériot <[EMAIL PROTECTED]>; PHP General List <[EMAIL PROTECTED]> Sent: Wednesday, July 11, 2001 4:00 AM Subject: RE: [PHP] How to fetch a "group by"

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

2001-07-11 Thread Tim Ward
o:[EMAIL PROTECTED]] > 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 extra

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

2001-07-10 Thread David Robley
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 > >

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

2001-07-10 Thread Ben Bleything
Did you try 'SELECT categorie,item FROM your_table GROUP BY categorie'? Ben -Original Message- From: Frédéric Mériot [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 5:41 AM To: PHP General List Subject: [PHP] How to fetch a "group by" Query? Hello (again) I've got a query whic