//gets the titles of the last 5 posts $sql="SELECT ID, post_date, post_title, post_status FROM wp_posts WHERE post_status = 'publish' ORDER BY post_date DESC limit 5"; //Run the sql //print ""; $result = mysql_query($sql); $color=0; while ($row = mysql_fetch_array($result, MYSQL_NUM)) { $postID=$row[0]; $post_date=$row[1]; $post_title=$row[2]; $post_title=stripslashes($post_title); $post_date_short=substr($post_date,0,10); $linkCode=""; print "$linkCode$post_date_short:
$post_title

"; } print "Read all the archives
"; mysql_free_result($result); ?>