Support » Fixing WordPress » Displaying 5 latest post on my external homepage

  • I am using the following code to display my 5 most recent post headlines on my homepage, which is 1 level up from my WP installation:

    <?php
    $how_many=5; //How many posts do you want to show
    require_once(“articles/wp-config.php”); // Change this for your path to wp-config.php file ?>
    <ul id=”whats-new”>
    <?
    $news=$wpdb->get_results(“SELECT ID,post_title FROM $wpdb->posts
    WHERE post_status= \”publish\” ORDER BY ‘timestamp’ DESC LIMIT “.$how_many);
    foreach($news as $np){
    print (”

    • <a href=\””);
      echo get_permalink($np->ID);
      print (“\”>$np->post_title
    • “);
      } ?>

      This appeared to be working fine at first, up until I had written more than 5 posts, now this code doesnt seem to display the newest ones, only the first 5 ever posts

      I have tried replacing timestamp with date as the ORDER BY setting

      Any ideas?

      Thanks

  • The topic ‘Displaying 5 latest post on my external homepage’ is closed to new replies.