CMS Made Simple Forums

Code: Select all

$mysql_host		= 'XXX';		
$mysql_user 		= 'XXX';		
$mysql_passwd 		= 'XXX';
$mysql_database 	= 'XXX';

MYSQL_CONNECT($mysql_host,$mysql_user,$mysql_passwd);
MYSQL_SELECT_DB( $mysql_database ) or die( "Unable to select database");
$today = time();

  $query2 = "SELECT * FROM wp_posts WHERE post_type = 'POST' AND post_status ='publish' ORDER BY post_date DESC LIMIT 8";
$result2 = mysql_query($query2) or die("Error: " . mysql_error());

echo "<div class='navleft'> <br />"; 
while($row = mysql_fetch_array( $result2 )) {
	// Print out the contents of each row into a table
echo "<h4>";
echo "<a href='";
	echo $row['guid']; 
echo "'>";

	echo $row['post_title'];

echo "</a>"; 
echo "</h4>";

}