[digitalSite]

Originally Posted by Logician

You are suppose to get last 5 in that forum. I get 5 in my test forum. Can it be because you have just 1 thread in that forum?

Ha! This is true! I do only have one post in this forum...I guess my question should be, how do I list threads from ALL forums? Would I have to add every forum here

WHERE t.forumid = '1','2','3', etc.? Thanks!

I tried removing this WHERE t.forumid = (because I want from ALL forums) and replaced it with WHERE t.open = '1' AND t.visible = '1', but then the titles don't get limited and it posts the entire title.

OMG, I'm having a hard time with this...I noticed that when I run your code, it cuts the title to the limit you specify, but when I copy/paste your code into my webtemplate, it diplays the number of posts correctly, but doesn't cut off the title...any ideas why yours works and mine doesn't?