Thanks for the reply php isnt my best subject really , i dont really get how to put it in to a certain place on my site , if you look at the Tottenham Page in my sig, there is a latest post box , any idea how i would get it into there ?
$db_host = 'localhost'
; #change to your host
$db_user = 'username'; #change to your user name
$db_password= 'password'; #change to your password
$db_name = 'database_name'; #change to your db name
Following the comments.
And then in this code:
$result = mysql_query("SELECT DISTINCT t.topic_id, t.topic_title, t.topic_replies, u.user_id, u.username, s.post_text
FROM phpbb_posts p, phpbb_topics t, phpbb_users u, phpbb_posts_text s
WHERE p.topic_id = t.topic_id AND t.topic_poster = u.user_id AND t.topic_first_post_id = s.post_id AND t.forum_id != 1 AND u.user_id != -1
ORDER BY p.post_time DESC LIMIT 10");
Change the LIMIT 10 to how ever many topics you want to show up there.