Calling recent posts to a webpage

[travis]

I used to know how to do this, with php how can you display recent posts to your forum on your home page?

[hl]

Depends on the forum software. If it's like most, it's in MySQL.

Just do a nice SELECT * FROM `tablecontainingpostsname` ORDER BY `fieldcontainingeithertimeorid` (ASC/DESC depending on the field you're ordering by, figure it out) LIMIT 5

5 can be changed of course.

[λ]

Alternatively, if your forum provides an RSS feed, you could use a package like XML_Feed_Parser (http://pear.php.net/manual/en/package.xml.xml-feed-parser.php) to parse and display it on your homepage.

although presumably you'd want some sort of caching mechanism to prevent your RSS feed from being hit on every load of the page

[travis]

Depends on the forum software. If it's like most, it's in MySQL.

Just do a nice SELECT * FROM `tablecontainingpostsname` ORDER BY `fieldcontainingeithertimeorid` (ASC/DESC depending on the field you're ordering by, figure it out) LIMIT 5

5 can be changed of course.

All right thanks a lot.
And no I don't have an RSS fead.