• Hello there. I have a question about whether something is possible. I have the following code importing my most recent blog entries to another page on my website. It works great, except, I’ve recently started using wordpress “pages” for a different type of article. I was able to stop these pages from showing up directly in the blog itself, but they are still importing to my site along with regular “blog” entries. I was wondering if there’s something I can add to this code that will make it ignore “pages” while continuing to import “blog entries.”

    I’m assuming (or at least hoping) that it’s as simple as inserting another parameter into this line: $result = mysql_query(“SELECT * FROM wp_posts WHERE post_status=’publish’ ORDER BY id DESC LIMIT 0,4”);

    Thanks in advance for any help.

    ————————————————————————-

    <?php
    $dbh=mysql_connect ("***********", "***********", "**********");
    mysql_select_db ("************");
    $result = mysql_query("SELECT * FROM wp_posts WHERE post_status='publish' ORDER BY id DESC LIMIT 0,4");
    while($row = mysql_fetch_array($result))
      {
    $title = $row[post_title];
    $content = $row[post_content];
    $id = $row[ID];
    $date = $row[post_date];
    $chars = preg_split('/ /', $date);
    $splitdate = $chars[0];
    $breakdate = preg_split('/-/', $splitdate);
    $year = $breakdate[0]; //This is the year
    //create arrays
    $monthfind = array ('/01/', '/02/', '/03/', '/04/', '/05/', '/06/', '/07/', '/08/', '/09/', '/10/', '/11/', '/12/', );
    $monthsreplace = array ('1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12',  );
    $month = $breakdate[1];
    ?>
    
    <h4><a href="<?php echo $row[guid]; ?>"><?php echo $title; ?></a></h4>
    <hr /><br />
    <?php
    if (preg_match("/<param/", $content))
    {
    echo $content;
    }
    else
    {
    echo nl2br($content);
    }
    echo "<h6>Posted ";
    Echo preg_replace ($monthfind, $monthsreplace, $month);
    echo ".";
    echo $breakdate[2];
    echo ".10</h6>";
    ?>
    
    <?php
    }
    ?>
Viewing 1 replies (of 1 total)
  • Thread Starter cutaia

    (@cutaia)

    Somehow I managed to figure it out myself! 😀

    I changed that line to this: (“SELECT * FROM wp_posts WHERE post_status=’publish’ && post_type!=’page’ ORDER BY id DESC LIMIT 0,4″)

    Can a moderator please mark this as resolved? Thanks in advance. 🙂

Viewing 1 replies (of 1 total)

The topic ‘PhP import question.’ is closed to new replies.