[wp-trac] [WordPress Trac] #3961: wp_get_archives('type=postbypost') missing ORDER BY

WordPress Trac wp-trac at lists.automattic.com
Mon Mar 12 16:29:28 GMT 2007


#3961: wp_get_archives('type=postbypost') missing ORDER BY
----------------------+-----------------------------------------------------
 Reporter:  mattbta   |       Owner:  anonymous
     Type:  defect    |      Status:  new      
 Priority:  normal    |   Milestone:  2.2      
Component:  Template  |     Version:  2.2      
 Severity:  major     |    Keywords:           
----------------------+-----------------------------------------------------
 wp-includes/general-template.php function wp_get_archives() line 417/418 :

 {{{
 ('alpha' == $type) ? $orderby = "post_title ASC " : $orderby = "post_date
 DESC ";
                 $arcresults = $wpdb->get_results("SELECT * FROM
 $wpdb->posts $join $where $orderby $limit");
 }}}

 Should be:

 {{{
 ('alpha' == $type) ? $orderby = "post_title ASC " : $orderby = "post_date
 DESC ";
                 $arcresults = $wpdb->get_results("SELECT * FROM
 $wpdb->posts $join $where ORDER BY $orderby $limit");
 }}}

-- 
Ticket URL: <http://trac.wordpress.org/ticket/3961>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software


More information about the wp-trac mailing list