[MrNase]

Hey

I need a query/code to get the following out of the database:

- the last 11 threads ordered by threadcreationtime

- the latest thread should have preview (only smilies should get parsed) and the first attached image should show up as a kind of teaser image.

- the other 10 threads should only have their headlines and a link to the thread.


I can do the first on my own.
The only problems are: how can i get a preview for the latest thread and only display the headlines for the other 10 threads? Another major problem would be to get the attachment working correct...

As you may see this should be for a news page. The most recent news should have an image and that image should be that image which is attached to the certain thread.

The other 10 threads should just give an overview about that the news. Just the title of the thread.

Here's what i would use for the first task:

PHP Code:

 SELECT thread.*
     FROM ".TABLE_PREFIX."thread AS thread
     WHERE open = '1'
     AND forumid IN (1,3,6)
     AND thread.visible = '1'
     ORDER BY threadcreationtime
     DESC LIMIT 11