A better way to consolidate some queries

[schwim]

Hi there everyone,

I'm using the following code to get a topic count of a forum:

$query = mysql_query("SELECT topic_id FROM phpbb_topics WHERE forum_id=1");
$topic_count = mysql_num_rows($query);

echo $topic_count;

And would like to use it to get the topic count of three forums. I know I can just repeat this query a few times and change forum_id, $query and $topic_count, but was wondering if there's a cleaner method of getting the count for three?

thanks,
json

[NogDog]

I think you could do:

$query = "
SELECT forum_id, forum_name, COUNT(*) AS `count` 
FROM phpbb_topics 
WHERE forum_id IN (1, 2, 3)
GROUP BY forum_id
";
$result = mysql_query($query);
while($row = mysql_fetch_assoc($result))
{
   echo "<p>{$row['forum_name']}: {$row['count']}</p>\n";
}