Can anyone help/mentor me with this simple hack please?

[Razasharp]

I am trying to get users latest X posted threads from specific forums showing in the user profiles. I have limited PHP Mysql knowledge (but am learning) so was wondering if someone could help me with this please? I'd very much appreciate it :)

I basically want to display 3 seperate blocks (1 for each forum) showing the latest 5 threads that a user has posted in their profile page:

See User's latest 5 threads posted in forum10

-Users latest thread 1 Title
date posted

-Users latest thread 2 Title
date posted

-Users latest thread 3 Title
date posted

-Users latest thread 4 Title
date posted

-Users latest thread 5 Title
date posted

See User's latest 5 threads posted in forum15

-Users latest thread 1 Title
date posted

-Users latest thread 2 Title
date posted

-Users latest thread 3 Title
date posted

-Users latest thread 4 Title
date posted

-Users latest thread 5 Title
date posted

See User's latest 5 threads posted in forum16

-Users latest thread 1 Title
date posted

-Users latest thread 2 Title
date posted

-Users latest thread 3 Title
date posted

-Users latest thread 4 Title
date posted

-Users latest thread 5 Title
date posted

I could probably do it with 3 querys but am sure it's possible with just one?

Any help is appreciated.

Thanks.

[Paul M]

You could obviously do it with three queries - you cannot do it directly with one (not that I can think of anyway). You could however run one query - and then use some php to extract the required data from the result.

[Razasharp]

You could however run one query - and then use some php to extract the required data from the result.

That's what I was thinking, but not sure how to go about it.. can you help me with this please Paul? :classic:

[Paul M]

Well I'm very busy, but I'll see what I can do, what do you want to know ?