Changeset 4039 for trunk/wp-includes/category.php

Timestamp:

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

Author:

ryan

Message:

Use AND instead of HAVING. #2604

File:

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

trunk/wp-includes/category.php

@@ -71 +71 @@
     if ( $hide_empty ) {
         if ( 'link' == $type )
-            $having = 'HAVING link_count > 0';
+            $where .= ' AND link_count > 0';
         else
-            $having = 'HAVING category_count > 0';
+            $where .= ' AND category_count > 0';
     }
 
@@ -81 +81 @@
         $number = '';
 
-    $categories = $wpdb->get_results("SELECT * FROM $wpdb->categories WHERE $where $having ORDER BY $orderby $order $number");
+    $categories = $wpdb->get_results("SELECT * FROM $wpdb->categories WHERE $where ORDER BY $orderby $order $number");
 
     if ( empty($categories) )