Support » Fixing WordPress » Listed categories will not order categories by ascending (ASC)

  • I can’t get the categories to list by new to old. I’ve already posted this, but for some reason, I can’t edit it to make changes.

    If I change the ‘order’ to equal ascending it will not take effect at all…

    Here is the full code:

                $catQuery = $wpdb->get_results(" SELECT * FROM $wpdb->terms AS wterms
    										     INNER JOIN $wpdb->term_taxonomy AS wtaxonomy
    										     ON ( wterms.term_id = wtaxonomy.term_id )
    										     WHERE wtaxonomy.taxonomy = 'category'
    										     AND wtaxonomy.parent = 0 AND wtaxonomy.count > 0");
                $catCounter = 0;
                foreach ($catQuery as $category) { //latest posts 
    				$catStyle = '';
    				if (is_int($catCounter / 2)) $catStyle = ' class="catAlt"';
    				echo '<TR HEIGHT="20" VALIGN="BOTTOM">
    				      <TD COLSPAN="2"><SPAN CLASS="style10">
    					  <div id="Category_format" style"text-align:center; font-family: Arial, Helvetica, sans-serif; font-size: 11px; color: #666666; line-height: 13px; font-weight: bold;">
    				query_posts('cat='.$category->term_id.'&showposts=99&orderby=category&order=desc'); //this controls the order of the posts with in categories ?>
    				<?php while (have_posts()) : the_post(); ?>
    					<tr><td align="right"><?php the_title(); ?></td><td align="left" style="line-height:50%;">
                        <span class="links"><?php the_content(); ?></span></td></tr>
    				<?php endwhile; ?>
                <?php }  ?>

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Listed categories will not order categories by ascending (ASC)’ is closed to new replies.