Changeset 2525 for trunk/wp-includes/functions.php

Timestamp:

04/09/2005 05:30:57 PM (21 years ago)

Author:

ryan

Message:

Implement order and orderby for get_posts(). ​http://mosquito.wordpress.org/view.php?id=1161 Props: RummandDan

File:

• trunk/wp-includes/functions.php (modified) (2 diffs)

trunk/wp-includes/functions.php

@@ -1053 +1053 @@
         if (!isset($r['offset'])) $r['offset'] = 0;
         if (!isset($r['category'])) $r['category'] = '';
-        // The following not implemented yet
-        if (!isset($r['orderby'])) $r['orderby'] = '';
-        if (!isset($r['order'])) $r['order'] = '';
+        if (!isset($r['orderby'])) $r['orderby'] = 'post_date';
+        if (!isset($r['order'])) $r['order'] = 'DESC';
 
         $now = current_time('mysql');
@@ -1064 +1063 @@
                 " WHERE post_date <= '$now' AND (post_status = 'publish') ".
                 ( empty( $r['category'] ) ? "" : "AND $wpdb->posts.ID = $wpdb->post2cat.post_id AND $wpdb->post2cat.category_id = " . $r['category']. " " ) .
-                " GROUP BY $wpdb->posts.ID ORDER BY post_date DESC LIMIT " . $r['offset'] . ',' . $r['numberposts'] );
-
+                " GROUP BY $wpdb->posts.ID ORDER BY " . $r['orderby'] . " " . $r['order'] . "  LIMIT " . $r['offset'] . ',' . $r['numberposts'] );
+        
     update_post_caches($posts);