...

View Full Version : GROUP BY Query Help



centenial
02-13-2007, 06:05 PM
Hi,

I have two tables:
- cars
- manufacturers

Each with many, many records. I want to display them in a drop-down menu like this:

manufacturer1
- car1
- car2
- car3
..so on
manufacturer2
- car1
- car2
- car3
..so on
and so on

I've gotten as far as:

SELECT id, name, manufacturer FROM cars GROUP BY manufacturer, name;

But I have no idea what to do next. Can anyone help me?

guelphdad
02-13-2007, 06:40 PM
read the albums/artists item in my signature. the php part of the article will do what you are looking for.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum