Changeset 4015

Timestamp:

07/11/2006 06:15:24 PM (19 years ago)

Author:

ryan

Message:

Allow limiting the number of cats to fetch.

File:

• trunk/wp-includes/category.php (modified) (3 diffs)

trunk/wp-includes/category.php

@@ -21 +21 @@
 
     $defaults = array('type' => 'post', 'child_of' => 0, 'orderby' => 'name', 'order' => 'ASC',
-        'hide_empty' => true, 'include_last_update_time' => false, 'hierarchical' => 1, $exclude => '', $include => '');
+        'hide_empty' => true, 'include_last_update_time' => false, 'hierarchical' => 1, $exclude => '', $include => '',
+        'number' => '');
     $r = array_merge($defaults, $r);
     if ( 'count' == $r['orderby'] )
@@ -27 +28 @@
     else
         $r['orderby'] = "cat_" . $r['orderby'];  // restricts order by to cat_ID and cat_name fields
+    $r['number'] = (int) $r['number'];
     extract($r);
 
@@ -74 +76 @@
     }
 
-    $categories = $wpdb->get_results("SELECT * FROM $wpdb->categories WHERE $where $having ORDER BY $orderby $order");
+    if ( !empty($number) )
+        $number = 'LIMIT ' . $number;
+    else
+        $number = '';
+
+    $categories = $wpdb->get_results("SELECT * FROM $wpdb->categories WHERE $where $having ORDER BY $orderby $order $number");
 
     if ( empty($categories) )