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

Timestamp:

07/24/2006 06:24:56 PM (20 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) )