recent posts

[miz]

simple query can do it :

for posts
[SQL] SELECT * FROM POSTS ORDER BY TIME DESC LIMIT 10 [/SQL]


or threads

[SQL]SELECT * FROM THREAD ORDER BY ID DESC LIMIT 10[/SQL]