[PHP] MySql PHP - Looking for the right command

Hello, I have a site that lists cars in a MySql database. I want to display on a page how many makes of each are in the database (Under the feild make) Like: Honda (30)//Then links to the honda page etc Toyota (25) Ford (7) Do you know what I mean. I know how to produce results from

Re: [PHP] MySql PHP - Looking for the right command

This is how you can do it (just tried it on my news with my news categoryID's) i'll modify slightly for your purpose with psuedo code ... SELECT carType,count(carType) FROM cars GROUP BY carType; --Joe On Fri, Apr 06, 2001 at 11:28:00AM +1200, YoBro wrote: Hello, I have a site that lists