This obvius belongs here, so now it's been moved..
How about somethign like this:
PHP Code:
$query=mysql_query("SELECT * FROM np_categories");
while($row= mysql_fetch_array($query))
{
$data=mysql_query("SELECT COUNT (*) FROM np_articles WHERE article_category_id = $row[category_id]");
$i_row=mysql_fetch_array($data);
echo $row["category_name"] . " (" . $i_row[0] . ")";
}
Or perhaps something like this:
PHP Code:
$query=mysql_query("SELECT * FROM np_categories");
while($row=mysql_fetch_array($query))
{
$data=mysql_query("SELECT * FROM np_articles WHERE article_category_id = $row[category_id]");
$i=mysql_num_rows($data);
echo $row["category_name"] . " (" . $i . ")";
}