Artikel nach benutzerdefiniertem Feld sortieren

<?php get_header(); ?>


<div id="content" class="narrowcolumn" role="main">
    <?php if (is_category()) {
    $pageposts = $wpdb->get_results("SELECT *
    FROM $wpdb->posts, $wpdb->postmeta
    WHERE $wpdb->posts.ID = $wpdb->postmeta.post_id
    AND $wpdb->postmeta.meta_key = 'reihenfolge'
    ORDER BY meta_value ASC", OBJECT);
 
    if ($pageposts) : foreach ($pageposts as $post): setup_postdata($post); ?>


            <div <?php post_class(); ?>>
                <h3 id="post-<?php the_ID(); ?>"><?php the_title(); ?></h3>
                


                <div class="entry">
                    <?php the_content() ?>
                </div>
            </div>


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


</div> 
<?php get_sidebar(); ?>
<?php get_footer(); ?>

<?php
$categoryvariable=$cat; // assign the variable as current category
$query= 'cat=' . $categoryvariable. '&orderby=date&order=ASC'; // concatenate the query
query_posts($query. 'cat=6&meta_key=reihe&orderby=meta_value&order=ASC'); // run the query
?>


<?php global $more;
// set $more to 0 in order to only get the first part of the post
$more = 0; 
?>
      
<!-- the Loop -->
<?php while (have_posts()) : the_post(); ?>


    <div <?php post_class(); ?>
        <h3 id="post-<?php the_ID(); ?>"><?php the_title(); ?></h3>
        <div class="entry">
                    <?php the_content() ?>
        </div>
    </div>


<?php endwhile; ?>


</div>




<?php get_sidebar(); ?>
<?php get_footer(); ?>