Advertisement
Guest User

Multiple Loops

a guest
Oct 2nd, 2011
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.97 KB | None | 0 0
  1. <?php
  2. $caty = 'Cat';
  3. $catymeta = get_post_meta($post->ID, $caty, TRUE);
  4.  
  5. global $wpdb;
  6. global $post;
  7. $querystr = "
  8. SELECT distinct wposts.*
  9. FROM $wpdb->posts wposts
  10.     LEFT JOIN $wpdb->postmeta wpostmeta ON wposts.ID = wpostmeta.post_id
  11.     LEFT JOIN $wpdb->term_relationships ON (wposts.ID = $wpdb->term_relationships.object_id)
  12.     LEFT JOIN $wpdb->term_taxonomy ON ($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)
  13.     WHERE $wpdb->term_taxonomy.term_id IN($catymeta)
  14. ";
  15.  
  16.  $pageposts = $wpdb->get_results($querystr, OBJECT);
  17. ?>
  18.  
  19.  
  20. <?php if ($pageposts): ?>
  21.     <?php global $post; ?>
  22.     <strong>Season 1</strong>
  23.     <ol>
  24.         <?php foreach ($pageposts as $post): ?>
  25.         <?php ob_start(); the_title(); $showtitle = ob_get_clean(); if (strpos($showtitle,'Season 1') !== false) { ?>  
  26.             <?php setup_postdata($post); ?>
  27.             <li><a href="<?php echo $recurl; ?>"><?php echo $showtitle; ?></a></li>
  28.         <?php } ?>
  29.         <?php endforeach; ?>
  30.     </ol>
  31. <?php endif; ?>
  32.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement