Cipher
10-10-2005, 01:43 AM
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?!
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?!