How can i take latest forum topics and show them on my new Site Layout

[hypnoticpimp]

Hey , Can someone please tell me how i can take like my latest 5 or 10 topics from a specifc section, of my forum, and show them on a section on my new site layout, not forum?, and does my site have to be .html or .php?

[Zubaz]

$query = mysql_query("SELECT * FROM `[vb_prefix]_thread` WHERE `open`='1' ORDER BY `dateline` DESC LIMIT 0,8");
There's your query, and it won't call closed threads.

And since you asked, yes - it has to be php.

[hypnoticpimp]

Thats a query lol. i need php code

[roosevelt]

You can use my RSSI package to do the same thing :). For example this is showing threads from Games category in my forum. http://www.relforums.com/vrssi.php?id=ltsf&fid=103

vRSSI MOD URL: https://vborg.vbsupport.ru/showthread.php?t=113214