Changeset 2525

Timestamp:

04/09/2005 05:30:57 PM (19 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);