GROUP BY Query Help

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?

read the albums/artists item in my signature. the php part of the article will do what you are looking for.