[Robert Basil]

Just an update on my progress...

I tried using the code:

SELECT t.threadid, t.title, t.firstpostid, t.lastpost, f.title as forumtitle, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, p.pagetext, t.iconid, t.forumid
FROM thread t
LEFT JOIN post p ON p.postid = t.firstpostid
LEFT JOIN forum f ON f.forumid = t.forumid
WHERE t.forumid
IN ( 19, 116 )
AND t.open = '1'
AND t.visible = '1'
GROUP BY f.title
ORDER BY forumtitle DESC
LIMIT 0 , 3

The code above does two things that confuse me. (Keep in mind I am a very novice mySQL guy, so I am easily confused)

#1. It only grabs one thread from each forum. (2 threads total on the page even though the limit is set to 3)

#2. The thread that it grabs is the oldest thread, not the newest one.

I've tried so many different query's I'm about ready to pull my hair out. Any ideas Logician??