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.
On Monday 12 August 2002 01:27 pm, Dan Koken wrote:
> 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 select statement similar to this:
> > SELECT DISTINCT type FROM equipement WHERE class = "microphones";
> > yet shows all 11 columns of the selected rows rather than just the
> > type column.
> > The only way I know how to show all the columns is to use SELECT *, or to
> > list all the columns manually like "SELECT id, type, class, ... etc."
> > But when I tried doing this:
> > SELECT DISTINCT type, id, staff_member, class, manufacturer, model,
> > description, picture, created, modified, published FROM equipment WHERE
> > class = "microphones";
> > I just got the exact same answer as if i would have done this:
> > SELECT * FROM equipment WHERE class = "microphones";
> > so it didn't help.
> > Can anyone offer a hint?
> > Thanks,
> > russ
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php