12-30-2009, 01:00 PM
[eluser]cinoob[/eluser]
I am creating a forum and would like to display the number of posts within each category. The database structure is as follows:
A category table holds the name of categories
A topics table holds topics for each category
A messages table holds responses to each topic
Can anyone help me with a query which would return all the columns in the categories table and a total count for the number of topics and responses to topics?
I am creating a forum and would like to display the number of posts within each category. The database structure is as follows:
A category table holds the name of categories
A topics table holds topics for each category
A messages table holds responses to each topic
Can anyone help me with a query which would return all the columns in the categories table and a total count for the number of topics and responses to topics?