Google it! / Yahoo it! / Bing it! / Ask it!

I’m talking here about extracting latest posts to a different site. I’m also assuming that the databases are on the same server.

So here is the script:

<?php
// connect to the database server
mysql_select_db('forum');

// run The query
$results = mysql_query("SELECT * FROM phpbb_topics ORDER BY topic_time DESC LIMIT 10");
if ($results) {
	while($rand = mysql_fetch_array($results)) {
		echo "<div>";
		echo "<a href='http://www.domain.com/forum/viewtopic.php?t=".$rand[0]."' target='_blank' title='Open in new window'>";
		echo $rand[6];
		echo "</a><br /><small>&raquo; added by ".$rand[16]."</small>";
		echo "</div>";
	}
}
else {
	echo "<p>Error: Forum not available.</p>";
}

mysql_select_db('main_site');
?>

The last line of the script reopens the previous connection, if any. If you don’t use any MySQL databases on your main site, then remove the last database selection line. You should take care and replace phpbb_ with your database prefix (usually phpbb_). You should also change the number of posts you want to extract (10 in my example). Feel free to open the phpbb_topics table and extract new info. I’m using $rand[x] to extract my info, where x is the column number in the phpbb_topics table (starting from 0).

Tweet