Gregg

sdenike

Now that’s the first one I’ve seen that really doesn’t remotely look like a blog. Nicely done.

Here’s the solution:

$today = current_time('mysql', 1);
          if ( $recentposts = $wpdb->get_results("SELECT $wpdb->posts.ID, $wpdb->posts.post_title FROM $wpdb->posts LEFT JOIN $wpdb->post2cat ON $wpdb->posts.ID = $wpdb->post2cat.post_id WHERE $wpdb->posts.post_status = 'publish' AND $wpdb->posts.post_date_gmt < '$today' AND $wpdb->post2cat.category_id = 1 ORDER BY $wpdb->posts.post_date DESC LIMIT 10")):
        ?>
        <?php

        foreach ($recentposts as $post) {
                 if ($post->post_title == '')
                     $post->post_title = sprintf(__('Post #%s'), $post->ID);
                 echo "<div class=\"lcoltxt\"><a href='".get_permalink($post->ID)."'>";
                 the_title();
                 echo '</a></div>';
        }

        ?>
        <?php endif; ?>