Re: [PHP-DB] Re: select distinct with all columns

2002-08-13 Thread russ arbuthnot
Perfect! Thanks. I'm still trying to get a handle on the GROUP BY command. It's still a little bit like magic to me. And in the manual, they don't really show how to use it like the way I wanted to use it. Thanks again, russ On Monday 12 August 2002 01:27 pm, Dan Koken wrote: > SELECT * > FROM

[PHP-DB] Re: select distinct with all columns

2002-08-12 Thread Dan Koken
SELECT * FROM equipement WHERE class = "microphones" GROUP BY type; Russ Arbuthnot wrote: > I have a mysql table named "equipment" with 11 columns named: id, > staff_member, class, type, manufacturer, model, description, picture, > created, modified, and published. > > I'm trying to write a