$show_blog = true;
if($show_blog){
//replace HOST, USER, PASS, DB_NAME with your DB details
$limit = 10;
$con = mysql_connect(HOST,USER,PASS);
if (!$con){ die('Could not connect: '); }
// make foo the current db
$db_selected = mysql_select_db('DB_NAME', $con);
if (!$db_selected) {
die ('Can\'t use db : ');
}
echo "<div class='left_tab'>Recent Posts...</div>
<div class='left_menu'>
<ul>";
$sSql = "SELECT `ID`,`post_title`, `wp_posts`.`guid` FROM `wp_posts` WHERE `wp_posts`.`post_status` = 'publish'
AND `wp_posts`.`post_type` = 'post' ORDER BY `wp_posts`.`post_date` DESC LIMIT 0, $limit";
$rs_blog = mysql_query($sSql,$con) or die("no connection");
while($row_blog = mysql_fetch_array($rs_blog)){
echo "<li><a href='".$row_blog['guid']."' title='".
htmlspecialchars(str_replace("'"," ",$row_blog['post_title']))."' target='_blank'>• ".htmlspecialchars($row_blog['post_title'])."</a></li>";
}
mysql_free_result($rs_blog);
echo "</ul>
</div>";
mysql_close($con);
}