opblog

hey thanks i got this but stuck on one thing i want to put category name with the post that showing here.. how can i do that…

<?php
  global $wpdb;
  $splitformat = '%A %B %Y';
  $sql = "SELECT ID, post_title, post_date
			FROM $wpdb->posts
			WHERE post_type = 'post' AND post_status = 'publish' AND post_date > '" . date('Y-m-d', strtotime('-3 days')) . "'
			ORDER BY post_date DESC
			";

  $posts = $wpdb->get_results($sql);
  $archives = array();
  foreach($posts as $post)
	{
		$key = strftime($splitformat, strtotime($post->post_date));
		$archives[$key][] = $post;
	}
  $output = $pre_HTML;
  	foreach($archives as $heading => $posts)
	{
		echo '<' . $headingtag . '>' . htmlentities($heading) . '</' . $headingtag . '>', "\n";
		echo '<ul>', "\n";

		foreach($posts as $post)
		{
			echo '	<li><a href="' . get_permalink($post->ID) . '">' . $post->post_title . '</a></li>', "\n";
		}

		echo '</ul>', "\n\n";
	}
?>

thanks