jasontwright

Looks like the following code works:

<?php
$how_many=5; //How many posts do you want to show
require_once("./news/wp-config.php"); // Change this for your path to wp-config.php file?>
<ul>
<?
$news=$wpdb->get_results("SELECT 'ID', 'post_title', 'post_date' FROM $wpdb->posts
WHERE 'post_status'= \"publish\" ORDER BY ID DESC LIMIT $how_many");
foreach($news as $np){
printf ("
<li><a href="/news/index.php?p=%s">%s</a></li>
", $np->ID,$np->post_title);
}?>