Sort or query the index page

[Chuckie]

vb Advanced cmps version.

I would like to figure out how I can pull 2 items from each forum in my news topic list.

Example:

At present I list 4 news forums on my home page. It pulls 4 of the latest topics from the accumulation of the 4 forums. Say 1,2,3,4

What I want to do is:
Pull 2 latest posts from forum 1, 2 from forum 2, 2 from forum 3 and 2 from forum 4. for a total of 8 posts.

Is this to much of a rewrite or is the a SQL statement I could input in the index page?

[Brian]

I don't think there would really be a good way to do this... I'm not sure if this would be a solution, but it would be fairly easy to change the query so that it pulls specific threadids/postids instead.

[Our Sponsors]

[Chuckie]

Yes, Tried that. It will pull that thread number you assign but if a new post in that forum is made it won't pull it.

I will find a solution and post it or give it to you.