Page reordering based on metadata

  • Resolved oliverbennett

    (@oliverbennett)


    16 years, 9 months ago

    Hi there,

    I wonder if it’s possible to list pages on a… er, page, and sort them different ways based on their metadata (or possibly tags or something else?).

    I’ve included 5 example pages in this image. Each page has a name of ‘date’ and value of 2009/2008/2007, and another name of ‘animals’ and a value of kittens/puppies/goldfish.

    How they would be ordered depends on the name, then value of the metadata.

    If anyone could first tell me if this is achiveable and if possible point me in the right direction that would be fantastic.

    Many thanks,
    Oliver

Viewing 2 replies - 1 through 2 (of 2 total)
  • esmi

    (@esmi)

    16 years, 9 months ago

    I think get_posts may be what you’re looking for.

    http://codex.ww.wp.xz.cn/Template_Tags/get_posts

    Thread Starter oliverbennett

    (@oliverbennett)

    16 years, 9 months ago

    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; ?>

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Page reordering based on metadata’ is closed to new replies.