MySQL, PHP and new posts?

[shunga]

Thanks for the code. I think I'm using a version of MySQL that doesn't support some of it. This is what I could get to work:

SELECT p.postid, p.username, p.userid, p.dateline, p.pagetext
FROM post AS p
WHERE visible = 1
ORDER BY dateline DESC
LIMIT 10

I also need links to the thread and the post, as well as the date and time.