PHP 统计论坛帖子数

Question

我正在尝试获取帖子数在“帖子”表中，

i have id,topic_id (topic_id= the topic id)

在“主题”表中，

i have id,f_id (f_id= the forum id )

我时不时地尝试，但不行我如何计算帖子数？例如:

<php?
$test2=mysql_query("SELECT *, COUNT(topic_id) AS post_count FROM posts t LEFT JOIN topics p ON p.id = t.id WHERE `f_id`='1' GROUP BY t.id") or die (mysql_error());
?>

Answer 1

尝试这个查询:

SELECT *, COUNT(topic_id) AS post_count 
FROM posts t 
LEFT JOIN topics p 
ON p.id = t.id AND `f_id`='1' 
GROUP BY t.id