Integration into main website

I just installed wordpress and I’m wondering how I can get the same neat posting but in my static website instead?

I read the tutorial but my sticking point is here:

<ol id="whats-new">
<?
$news=$wpdb->get_results("SELECT <code>ID</code>,<code>post_title</code> FROM $wpdb->posts
WHERE <code>post_type</code>=\"post\" AND <code>post_status</code>=\"publish\" ORDER BY post_date DESC LIMIT $how_many");
foreach($news as $np){
printf ("<li><a href=\"%s\">%s</a></li>", get_permalink($np->ID),$np->post_title);

}?>
</ol>

This doesn’t grab everything I want!
1. I would like to be able to specify a category to pull the latest from
2. Include the_content, poster, post_time
3. The opportunity for people to comment

Help me forum peoples!

Thanks!