query help or can it combined in to one

[adrianuk29]

I have worked out how to display and group the cars from the database and output this to the page using the following query

$query = "SELECT manufacturer, count(*) AS cnt FROM manufacturers_table WHERE manufacturer= '$manufacturer' GROUP BY manufacturer";

When it outputs it shows me the manufacturer and how many cars the manufacturer has for example

ford (3)

vauxhall (2)

What I would like to able to show is the car models directly underneath the manufacturer and group by models for example

Ford (3)
Fiesta (2), Escort (4), Kar (2)

vauxhall (2)
Vectra (4), Corsa (2)

I have tried and tried with the query but I still cannot get it. If anyone could show me some examples that would be appreciated.

Thank you in advance

[nemonoman]

Can't be done exactly as you want in one query.

You'll have to set up one query for the mfgs,

THen foreach manufacturer
a second query based on model