Hi,
I am trying to summarise the activity within a forum. The
forum contains 4 different discussion boards you can post to, and I
want to list each discussion board, along with the 5 latest threads
within each discussion board. (each thread is assigned a forumid
value which is linked to a 'forums' table containing the forum
name)
I have created a page that almost works perfectly. It is made
up 2 repeat regions: 1 for the 4 discussion boards, and another for
the threads within them. As I said, this is working almost
perfectly, but there is a problem. The second repeat region (for
the threads) is not doing the repeat for each discussion board. ie,
If I set the number of repeats to 20, it will display 20 threads
from the first forum, rather than 5 from each of the forums. If I
add 'GROUP BY forumid' to the query it returns only 1 result from
each forum.
I have attached the code - if anyone can help me out on this
I'd be really grateful - am so close and it's really frustrating!
Thanks a lot
1
Reply
AdChoices