WordPress.org

1. Damien
   Member
   Posted 2 years ago #
   

   I'm trying to add pagination to a custom query that pulls the top voted articles from the DB. After every two articles I'm trying to insert something, via a count. So far my efforts have been pretty bad, the count is screwed and I have no idea how pagination fits in.

   so...
   -Grab top voted posts & order them.
   -After every two posts/articles, insert extra content, using a count.
   -pagination needed for my many pages of content.

   <?php
   // grab top voted posts in order (works okay)
   
   $query_sql = "SELECT like_pid FROM " . $wpdb->prefix ."likes_count ORDER BY like_count DESC";
   $query_result = $wpdb->get_col( $wpdb->prepare ($query_sql, OBJECT));
   if ($query_result) {
   foreach ($query_result as $post_id) {
   $post = &get_post( $post_id );
   setup_postdata($post);
   ?>
   
   // Now count out two articles (fail?)
   
   <?php $count++; ?>
   <?php if ($count%2== 0) : ?>
   
   // Show the two articles
   
   <?php else : ?>
   
   //Now do something else
   
   <?php endif;?>
   <?php } ?>
   <?php } ?>
   
   <div class="next"> <?php next_posts_link('&raquo;' ,0); ?></div>
   <div class="previous"> <?php previous_posts_link('&laquo;' ,0); ?>

   Any help appreciated much.

2. Damien
   Member
   Posted 1 year ago #
   

   Solved everything except getting pagination working with my custom query, not sure how '$wp_query->query('showposts=5'.'&paged='.$paged); fits in here.

   My working loop, without pagination. Any working tips on fitting pagination into my loop here and I owe you a beer or two.

   <?php global $wpdb;
   $query_sql = "SELECT like_pid FROM " . $wpdb->prefix ."likes_count ORDER BY like_count DESC LIMIT 6 OFFSET 0";
   $query_result = $wpdb->get_col( $wpdb->prepare ($query_sql, OBJECT));
   if ($query_result) {
   foreach ($query_result as $post_id) {
   $post = &get_post( $post_id );
   setup_postdata($post); ?>
   
   <?php $count++;
   if ($count%2== 0) : ?>
   
   <-- do the loop, count out two articles -->
   
   <?php else : ?>
   
   <-- do something after every two articles -->
   
   <?php endif;?>
   
   <?php } ?>
   <?php } ?> //ugly but works

Topic Closed

This topic has been closed to new replies.