I have a database structure that has 2 columsn: part and parttype

I want to group the group the query by part types such that i can produce something that looks like

doors, total doors (50)
door1
door2
...
door50

windows, total doors (3)
windows1
windows2
windows3

How do I do this?

I can do parttype, total parts using this query
Code MySQL:
SELECT `description` , count( `description` ) AS thecount
FROM `dynamationlive`
GROUP BY  `description`
ORDER BY `thecount` DESC