danpacey

ok, an update. I’m getting the right amout of results from this code, but not the actual values.

<?php $querystr = "
SELECT DISTINCT wp_postmeta.* FROM wp_postmeta
WHERE $wpdb->postmeta.meta_key = 'area'

 ";

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

?>
 <?php if ($pageposts): ?>
  <?php foreach ($pageposts as $post): ?>
    <?php setup_postdata($post); ?>

	<option value="<?php echo get_post_meta($post->ID, 'area', true); ?>"><?php echo get_post_meta($post->ID, 'area', true); ?></option>

   <?php endforeach; ?>
<?php endif ?>1

I have 9 “area” values in the wp_postmeta table at present, and i’m getting a list with 9 <option> tags.. but there is nothing in-between the option tags..

putting this here in case anyone has any idea what i’m doing wrong. Many thanks again.

ok at the moment i am trying to run this code, but it’s not generating any results.

<?php $querystr = "
SELECT DISTINCT wp_posts.* FROM wp_posts
LEFT JOIN $wpdb->postmeta ON($wpdb->posts.ID = $wpdb->postmeta.post_id)
LEFT JOIN $wpdb->term_relationships ON($wpdb->posts.ID = $wpdb->term_relationships.object_id)
LEFT JOIN $wpdb->term_taxonomy ON($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)
WHERE $wpdb->term_taxonomy.term_id = 3,4,5,6,7,8,9
AND $wpdb->term_taxonomy.taxonomy = 'category'
AND $wpdb->posts.post_status = 'publish'
AND $wpdb->postmeta.meta_key = 'area'
ORDER BY $wpdb->postmeta.meta_value ASC

 ";

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

?>
 <?php if ($pageposts): ?>
  <?php foreach ($pageposts as $post): ?>
    <?php setup_postdata($post); ?>

	<option value="<?php echo get_post_meta($post->ID, 'area', true); ?>"><?php echo get_post_meta($post->ID, 'area', true); ?></option>

	<?php endforeach; ?>
<?php endif ?>

any ideas?

will keep trying in the meantime!

Also: if I change the submenu code to

‘if(in_category(‘2′)’

for example, the correct class is called. Therefore.. the Page MUST be in Cat 3. It’s the only explanation.