RE: [PHP-DB] grouping by category

2002-04-04 Thread Jonathan Hilgeman
Hi Big Al, You're just running full-steam ahead into these mailing lists. :) Anyhow, as olinux pointed out, you can get everything you want in one query, but I would choose a different query (no need to GROUP BY category), and then use a multi-dimensional array to organize the data. Here's my ver

Re: [PHP-DB] grouping by category

2002-04-03 Thread olinux
Here's a start - take a look at the results in phpmyadmin to get an idea of how to loop the result SELECT url, author, name, category FROM hwureviews GROUP BY category olinux --- Alex Behrens <[EMAIL PROTECTED]> wrote: > Hey Guys, > > I'm trying to get my script to group all my reviews > by ca