I am creating a forum but I am stuck on the page that would list all topics and the amount of posts in each thread. <BR><BR>I created my table with autonum as PK, and have title and comments fields. I want to list all distinct titles in order of last posted date, and display how many posts each title has.<BR><BR>Am I going about this wrong putting everthing into one table? Should I run a query and subquery for each title to find number of posts? <BR><BR>I hope this was clear,<BR><BR>thanks.