![]() |
Pulling a specific number of threads from each forum.. can it be done in one query?
What I need to do, is write a query that pulls the latest 4 threadids out of a specified list of forumids individually.
So basically, if I was specifying forumids 1 and 2, the query would display two lists of the four latest threadids from those forums. The output at the mysql console would look something like this Code:
Forumid |Threadid Thanks :) |
PHP Code:
|
The problem with that query is that I want the 4 latest threads from each forum... that query takes the 4 latest threads aggregated together from both forums.
If two forums are specified, the query should return 8 values - 4 threads from the first forum, and 4 threads from the second forum. I haven't been able to figure out how to do this without running a seperate query for each forum. Thanks for the reply anyway. ;) |
All times are GMT. The time now is 11:00 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|