Detect if post or page

  • Marko Jakic

    (@markzero)


    14 years, 2 months ago

    How to detect in db query whether I got a post or page?

    $result = $wpdb->get_results("SELECT comment_count,ID,post_title FROM $wpdb->posts ORDER BY comment_count DESC LIMIT 0 , 5");

    Here I get popular posts, but I get “About” page also.

    foreach ($result as $post) {
 setup_postdata($post);
 // do some stuff
}

    So, I would like to check whether $post is page, if it is , then just jump it, or somehow to change query – to ignore pages, e.g. “AND NOT page” 🙂

Viewing 2 replies - 1 through 2 (of 2 total)
  • Mark / t31os

    (@t31os_)

    14 years, 2 months ago

    $result = $wpdb->get_results("SELECT comment_count,ID,post_title FROM $wpdb->posts WHERE (post_type = 'post' AND post_status = 'publish') ORDER BY comment_count DESC LIMIT 0 , 5");
    MichaelH

    (@michaelh)

    14 years, 2 months ago

    foreach ($result as $post) {
echo $post->post_type;
echo $post->post_status;
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Detect if post or page’ is closed to new replies.