WordPress.org

1. a2cmedia
   Member
   Posted 8 months ago #

   I have created a function as follows:

   function get_post_by_custom_field($day) {
   
   global $wpdb;
   
    $querystr = "
       SELECT wposts.*
       FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta
       WHERE wposts.ID = wpostmeta.post_id
       AND wpostmeta.meta_key = 'day'
       AND wpostmeta.meta_value = '" . $day . "'
       AND wposts.post_status = 'publish'
       AND wposts.post_type = 'post'
       ORDER BY wposts.post_date DESC
    ";
   
    $pageposts = $wpdb->get_results($querystr, OBJECT);
   
   if ($pageposts):
   
     foreach ($pageposts as $post):
       global $post;
       setup_postdata($post);
   	//Echo the output
   	 the_title();
   	echo '<br />';
     endforeach;
   
   endif;
   
   }

   Is was taken from the page:

   http://codex.wordpress.org/Displaying_Posts_Using_a_Custom_Select_Query

   The problem I have is the_title() that is returned are not the title's of the results - however it is returning the correct ammount of results.

   Any help please?

Reply

You must log in to post.