Welcome Guest, Not a member yet? Register   Sign In
mySQL count question
#1

[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?


Messages In This Thread
mySQL count question - by El Forum - 12-30-2009, 01:00 PM
mySQL count question - by El Forum - 12-30-2009, 01:06 PM
mySQL count question - by El Forum - 12-30-2009, 04:33 PM
mySQL count question - by El Forum - 12-30-2009, 05:44 PM
mySQL count question - by El Forum - 12-30-2009, 06:27 PM
mySQL count question - by El Forum - 12-30-2009, 09:05 PM
mySQL count question - by El Forum - 12-30-2009, 10:28 PM
mySQL count question - by El Forum - 12-31-2009, 06:45 AM



Theme © iAndrew 2016 - Forum software by © MyBB