oliverbennett

My Google-Fu must be weak. On a second search I found the answer:

ob_start();
the_content();
$content = ob_get_clean();

http://digwp.com/2009/07/putting-the_content-into-a-php-variable/

Hey t31os,

Thanks for the suggestion. Sorry, I should have said, I was half-aware of this, but I’m unsure how to extract informatiom from two seperate fields/values in the same query.

As I understand it the field value is being taken from postmeta.meta_key for use in postmeta.meta_value, so in order to do something like:

ORDER BY ABS('$wpdb->postmeta.meta_value') DESC, day DESC

I’m trying to understand how to access the ‘month’ AND ‘day’. Hope that makes sense.

Nice kitten, by the way 😀

Thanks, esmi.

Just in case anyone else is interested I ended with this:

<?php
$querystr = “
SELECT wposts.*
FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta
WHERE wposts.ID = wpostmeta.post_id
AND wpostmeta.meta_key = ‘type’
AND wposts.post_type = ‘page’
ORDER BY wpostmeta.meta_value DESC
“;
$pageposts = $wpdb->get_results($querystr, OBJECT);
?>

And then:

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

” rel=”bookmark” title=”Permanent Link to <?php the_title(); ?>”><?php the_title(); ?>

<?php echo get_post_meta($post->ID, “type”, $single = true);?>

<?php endforeach; ?>

<?php else : ?>
<h2 class=”center”>Not Found</h2>
<p class=”center”>Sorry, but you are looking for something that isn’t here.</p>
<?php include (TEMPLATEPATH . “/searchform.php”); ?>
<?php endif; ?>