All News

    [insert_php] global $wpdb;
    $news_results = $wpdb->get_results(“select term_id as id from wp_terms where name like ‘news’;”);
    if ($news_results && $news_results[0])
    {
    $news_id=$news_results[0]->id;
    }
    $news_sql=”(select object_id from wp_term_relationships where term_taxonomy_id=”.$news_id.”)”;
    $sql=”select * from wp_posts where post_type like ‘post’ and post_status not like ‘trash’ and ID in “. $news_sql .” order by id desc limit 55″;
    $posts=$wpdb->get_results($sql);
    foreach ($posts as $post)
    {
    foreach ($posts as $post)
    {
    $link = ‘/news/’.$post->ID;
    print(“

  • $post->post_title
  • “);
    }
    }

    [/insert_php]

Leave a Reply

Your email address will not be published. Required fields are marked *

*