Get pages list with custom fields

Thanks mate,

When I use that statement Im not returning any results… See function here.

function the_partners02() {
	 // $args = array(
	 // 		 	 		'meta_query' => array(
	 // 		 	 			       array(
	 // 		 	 			        'meta_key' => 'Partner_Level',
	 // 		 	 			        'meta_value' => 'Gold' ),
	 // 		 	 					'post_type' => 'page',
	 // 		 	 					'post_status' => 'publish' ));
	 // 		 	 			$pages = get_pages( $args );

	$args = array(
		'meta_key ' => 'Partner_Level',
		'meta_value' => 'Gold',
		'post_type' => 'page',
		'post_status' => 'publish'
		);

	$pages = get_pages( $args );
foreach ( $pages as $page ) {
			  	$option = '<option value="' . get_page_link( $page->ID ) . '">';
				$option .= $page->post_title;
				$option .= '</option>';
				echo $option;
		 	  }

}

[Moderator Note: Please post code or markup snippets between backticks or use the code button. As it stands, your code may now have been permanently dmaged/corrupted by the forum’s parser.]

Hi Jon,

It is truly returning no results.. Im not erroring at all…

Hmm strange one

Hi Jon,

Yeah thats the approach I took, I went back to my original select statement and voila it worked. I will go back to review why the get_pages approach didn’t work, everything looked right from the advice I got here and over at StackOverflow, so its got me wondering thats for sure..

Thanks for you help…

function the_partners($cpLevel) {
	global $wpdb;

	 $querydetails = "
	   SELECT wposts.*
	   FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta
	   WHERE wposts.ID = wpostmeta.post_id
	   AND wpostmeta.meta_key = 'Partner_Level'
	   AND wpostmeta.meta_value = '$cpLevel'
	   AND wposts.post_status = 'publish'
	   AND wposts.post_type = 'page'

	   ORDER BY wposts.post_title ASC
	 "; 

	$pageposts = $wpdb->get_results($querydetails, OBJECT);

	echo "<ul class=\"logobox clearfix\">";
			foreach ( $pageposts as $page ) {
					$option = '<li>';
					$option .= '<a href="' . get_page_link( $page->ID ) . '">' . get_the_post_thumbnail( $page->ID ) . '</a>';
					$option .= '</li>';
					echo $option;
			}
	echo "</ul>";
}