Counting records in a categorie

[djdaz]

I have this list of categories on my site, EG

Computers
Directory
E-Zine
Entertainment & Music
Food & Drink
Game
General

I want to put how many sites are in these categories next to them, like this

Computers (5)
Directory (7)
E-Zine (5)
Entertainment & Music (2)
Food & Drink (4)
Game (9)
General (5)

My way would be to make a mysql_query for each categorie to count all records which are in that categorie. But would there be a simpler way than that?

Thanks

[Frederick]

You are looping through to display the list of categories. Your sub-categories that are the sites must have a relations to the categories.
Just place a query in the loop that references the category ID number.

$sql = mysql_query("SELECT count(subcatid) FROM site_links WHERE catid = ".$cat['catid']." ");
$siteCount = mysql_result($sql,0,0);
echo $siteCount;

[djdaz]

all rite, cheers for that 🙂