WordPress.org

1. 2nic
   Member
   Posted 1 year ago #

   hello,

   for some mysterious reason, i can't use the query_posts() at all on my new blog. i was used to use it, and quite fan of it.

   could it be because for the first time i used sandbox (created a theme based on sandbox?)

   this is what i tried in archive.php :

   <?php query_posts($query_string.'&order=ASC'); ?>
   <?php if (have_posts()) : ?>

   as it didnot work out, i tried with :

   <? $order='ASC';
   $myquery = new WP_Query("order=$order");
   ?>
   <?php if($myquery->have_posts()) : ?>

   which is actually still written in tht page, but not working at all : posts are still displayed in descending order.

   i created a template that i'm using within a page, and it works nice. the problem is with this code is i'm obliged to have all posts listed on a single page, because if i limit the number of posts (using LIMIT at the end of the query), i can't navigate through pages ( can't use the defautl function as <?php posts_nav_link(); ?>for instance.)

   would anybody have an idea?

   thanks in advance,

   <?php
   /*
   Template Name: Reverse
   */
   ?>
   <?php get_header() ?>
   
   <div id="container" style="width:650px;">
     <div id="content" >
       <?php //query_posts('orderby=date&order=ASC'); ?>
       <?php
   
    $querystr = "
       SELECT wposts.*
       FROM $wpdb->posts wposts
       WHERE wposts.post_status = 'publish'
       AND wposts.post_type = 'post'
       ORDER BY wposts.post_date ASC
    ";
   
    $pageposts = $wpdb->get_results($querystr, OBJECT);
    ?>
       <div id="nav-above" class="navigation">
         <?php posts_nav_link(); ?>
       </div>
       <?php if ($pageposts): ?>
       <?php foreach ($pageposts as $post): ?>
       <?php setup_postdata($post); ?>
       <div  id="post-<?php the_ID() ?>" class="<?php sandbox_post_class() ?>">
         <div class="entry-date" style="margin-bottom:5px"> <?php printf(__('%1$s  %2$s', 'sandbox'), the_date('', '<b>', '</b><br /><br />', false), get_the_time()) ?>
           <?php edit_post_link(__('Edit', 'sandbox') ); ?>
         </div>
         <div style="margin-top:0; padding-top:0;"  class="entry-content">
           <?php the_content(''.__('Read More <span class="meta-nav">&raquo;</span>', 'sandbox').''); ?>
           <?php wp_link_pages('before=<div class="page-link">' .__('Pages:', 'sandbox') . '&after=</div>') ?>
         </div>
         <div class="entry-meta"> </div>
       </div>
       <!-- .post -->
       <?php //comments_template() ?>
       <?php endforeach; ?>
       <?php endif; ?>

   kind regards, veronique

2. 2nic
   Member
   Posted 1 year ago #

   so, here i am again

   what is exactyle the query_posts() function doing, is what i don't know.

   it is written :

   function &query_posts($query) {
   	unset($GLOBALS['wp_query']);
   	$GLOBALS['wp_query'] =& new WP_Query();
   	return $GLOBALS['wp_query']->query($query);
   }

   i die several things
   

   <?php $page = (get_query_var('paged')) ? get_query_var('paged') : 1;
   $query_string=$query_string."&paged=$page&order=ASC";
   echo "$query_string <br />";
   query_posts($query_string); ?>

   the echoed query_string gives this :
   "paged=4&year=2008&monthnum=03&paged=4&order=ASC "

   which is quite what i am looking for, but, no result on the page

3. 2nic
   Member
   Posted 1 year ago #

   so i tried this :

   <?
   echo " avant $request ";
   $request = str_replace ("DESC", "ASC", $request);
   echo "après $request";
   ?>

   and... i finally had my posts in a reverse order - bien sûr, c'est triché...

   but, of course the navigation through the pages does not work.

   so, i'm not so sure i found my solution.

   kind regards,

   any help welcome !

4. Otto42
   Moderator
   Posted 1 year ago #

   I don't understand the problem. This code will work:
   

   <?php query_posts($query_string.'&order=ASC'); ?>
   <?php if (have_posts()) : ?>

   What is it giving you instead?

5. 2nic
   Member
   Posted 1 year ago #

   so, i did this :

   <?
   echo  " //avant $request ";
   echo "page $page";
   $request = str_replace ("DESC", "ASC", $request);
   if (ereg ("5, 5", $request)) $request =  str_replace ("5, 5", "5, 10", $request);
   if (ereg ("10, 5", $request)) $request =  str_replace ("10, 5", "10, 15", $request);
   if (ereg ("15, 10", $request)) $request =  str_replace ("15, 10", "15, 20", $request);
   echo "après $request";
   ?>

   well, it works... but

   result here :

   http://www.historyze.org/veronique-m/2008/03

6. 2nic
   Member
   Posted 1 year ago #

   hello Otto42,
   millions of thanks, and thanks again

   why is it that it now works and what would the difference be between what i tried (well one of the things i tried :

   <?php get_header() ?>
   <?php query_posts($query_string.'&order=ASC'); ?>
   
   	<div id="container">
   		<div id="content">
   
   		<?php if (have_posts()) : ?>

   and the code I copied from you (and pasted) :

   <?php query_posts($query_string.'&order=ASC'); ?>
   <?php if (have_posts()) : ?>

   is not really clear to me.

   but again : thanks !

7. Otto42
   Moderator
   Posted 1 year ago #

   Well, there is no difference. That was sort of my point, I copy and pasted your original code. That code should have worked in the first place. Maybe you made a typo?

8. 2nic
   Member
   Posted 1 year ago #

   you're right, there's no difference.

   the difference is, i understand it now, that i thought i had disabled one by one each plugin, to check whether...

   but, i've just realised that i might had thougt i had deactivated "WP-Sticky 1.10" (the new 2.5 panel (?) sometimes deactivates ou ractivates something else than what you wished).

   the great culprit (?) (coupable) is the WP-Sticky 1.10
   sorry for my english

   but thanks again for your attention

Topic Closed

This topic has been closed to new replies.