-
[insert_php]
global $wpdb;
- $post->post_title
$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(“
“);
}
}