View Full Version : GROUP BY Query Help

02-13-2007, 06:05 PM

I have two tables:
- cars
- manufacturers

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

- car1
- car2
- car3
..so on
- 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?

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