Well in my Forum, i want to make topics and in the home page, show the user how many threads and posts in each topic, my DB For threads Contains 3 tables:
sure that's not all, but that wt i need to view this, so i tried the group by with Only topics and threads and it worked pretty fine, but cant make it with the Posts, so any help please?!
Cipher_kero
Member
745 Points
149 Posts
GROUP BY Prob
Oct 09, 2005 11:26 PM|LINK
Well in my Forum, i want to make topics and in the home page, show the user how many threads and posts in each topic, my DB For threads Contains 3 tables:
Topics(TopicID, Title)
Threads(ThreadID, TopicID)
Posts(PostID, ThreadID)
sure that's not all, but that wt i need to view this, so i tried the group by with Only topics and threads and it worked pretty fine, but cant make it with the Posts, so any help please?!