Rose

I have 155 published posts. That shouldn’t be too many, should it?

<?php /*
Template Name: Post Index by Genre
*/ ?>

<?php get_header(); ?>

    <?php

       // Use filters to sort a query on terms of a selected taxonomy.
       // See http://wordpress.mcdspot.com/2010/05/30/filters-to-modify-a-query/
       // for the code of the filters used.

       $taxonomy = 'genre';
       $mam_global_join = "JOIN $wpdb->term_relationships tr ON ($wpdb->posts.ID = tr.object_id)
      JOIN $wpdb->term_taxonomy tt ON (tr.term_taxonomy_id = tt.term_taxonomy_id AND tt.taxonomy = '$taxonomy')
      JOIN $wpdb->terms t ON (tt.term_id = t.term_id)";

       $mam_global_fields = ", t.name AS term_name";

       $mam_global_orderby = "term_name ASC, $wpdb->posts.post_title ASC";

$args = array(
		  'posts_per_page' => -1,
          'ignore_sticky_posts' => 1,
          'post_type' => 'post',
       );
       $q = new WP_Query($args);

       $mam_global_join = $mam_global_fields = $mam_global_orderby = ''; // Turn off filters
       print_r('<p>REQUEST:');print_r($q->request);print_r('</p>');
       //print_r('<p>POSTS:');print_r($q->posts);print_r('</p>');

       if ($q->have_posts()) {
          $current_term = '';
          while ($q->have_posts()) {
             $q->the_post();
             if ($current_term != $post->term_name) {
                $current_term = $post->term_name;
                echo "<h2>TERM: $current_term</h2>";
             }
             echo "<p>TERM:$post->term_name &nbsp; &nbsp;  $post->post_title</p>";
          }
       }

    ?>

<?php get_footer(); ?>

I uncommented and tried again using -1. I still only get a blank page.

Anyone know how to call up ALL posts using the above code? This isn’t working:

$args = array(
	  'numberposts' => -1,
          'ignore_sticky_posts' => 1,
          'post_type' => 'post',
       );
       $q = new WP_Query($args);

Nor is:

$args = array(
	  'posts_per_page' => -1,
          'ignore_sticky_posts' => 1,
          'post_type' => 'post',
       );
       $q = new WP_Query($args);

I created a template with the following code:

<?php /*
Template Name: Post Index by Genre
*/ ?>

<?php get_header(); ?>

    <?php

       // Use filters to sort a query on terms of a selected taxonomy.
       // See http://wordpress.mcdspot.com/2010/05/30/filters-to-modify-a-query/
       // for the code of the filters used.

       $taxonomy = 'genre';
       $mam_global_join = "JOIN $wpdb->term_relationships tr ON ($wpdb->posts.ID = tr.object_id)
      JOIN $wpdb->term_taxonomy tt ON (tr.term_taxonomy_id = tt.term_taxonomy_id AND tt.taxonomy = '$taxonomy')
      JOIN $wpdb->terms t ON (tt.term_id = t.term_id)";

       $mam_global_fields = ", t.name AS term_name";

       $mam_global_orderby = "term_name ASC, $wpdb->posts.post_title ASC";

       $args = array(
          'ignore_sticky_posts' => 1,
          'post_type' => 'post',
       );
       $q = new WP_Query($args);

       $mam_global_join = $mam_global_fields = $mam_global_orderby = ''; // Turn off filters
       //print_r('<p>REQUEST:');print_r($q->request);print_r('</p>');
       //print_r('<p>POSTS:');print_r($q->posts);print_r('</p>');

       if ($q->have_posts()) {
          $current_term = '';
          while ($q->have_posts()) {
             $q->the_post();
             if ($current_term != $post->term_name) {
                $current_term = $post->term_name;
                echo "<h2>TERM: $current_term</h2>";
             }
             echo "<p>TERM:$post->term_name &nbsp; &nbsp;  $post->post_title</p>";
          }
       }

    ?>

<?php get_footer(); ?>

All I got was a list of the 10 most recent posts. It didn’t even display the genre at all. Could you tell me what I’m doing wrong?

Yes, that’s pretty much what I want to do. Honestly, I’ll be surprised if there *is* a way to do it, but it never hurts to ask, right? In the meantime, I can use post ids; it’ll just be harder.

I managed to add the custom field “Notes” appear by inserting it right before $the_event, like so:

$jdata['event'] = '<p><b>Notes:</b> '.get_post_meta($p->ID, 'Notes', true).'</p>'.$the_event;
$jdata['subject'] = apply_filters( 'the_title', $p->post_title );

Now my issue is that I can’t seem to figure out how to make an “if” statement, so that the string of text I’ve added before $the_event only appears if the “Notes” custom field actually exists.

P.S. my taxonomy.php file currently looks like this:

<?php
get_header();
    $term = get_term_by( 'slug', get_query_var( 'term' ), get_query_var( 'taxonomy' ) );
?>

				<h1 class="page-title"><?php
					    printf( __( 'Posts classified under: %s', 'supernatural' ), '<span>' . $term_name . '</span>' );
				?></h1>
				<?php
					if ('' != $term_descr ) {
echo "<p>$term_descr</p>\n";
}
				?>

<?php get_footer(); ?>