[Kayn]

I'm not a total slouch when it comes to SQL, but I am stumped on this one.

I'm pulling the latest 10 posts out of the post table in vB in a specific forum, however it's not actually pulling the latest 10 posts. I went and posted a new thread, and responded to other threads (as did other members), but it's sticking to the same results.

Here's the query:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

Here's what it's outputting - http://pluh.com/index.php (look on the right side where it has "last 10 posts"

And here are the forums - http://pluh.com/forums

The Pluh Bored is the forum I'm pulling from here (id = 1). Why why why does this not work? Any insight?

Thanks!

[Marco van Herwaarden]

Could it maybe be that you are only retrieving post with an icon set?

I suggest you change the use of the icon & thread tables to LEFT JOINS.

[Kayn]

Hmm, good point. Do you have an example (I am not familiar with joins... as I should be). Thanks!

[Marco van Herwaarden]

Something like:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

[Kayn]

Wow, thanks. Works extremely well now.

I have a lot to learn about joins and SQL in general.