Changeset 7288 for trunk/wp-admin/upload.php

Timestamp:

03/14/2008 08:39:07 AM (18 years ago)

Author:

matt

Message:

Only show months that actually have attachments.

File:

• trunk/wp-admin/upload.php (modified) (1 diff)

trunk/wp-admin/upload.php

@@ -143 +143 @@
 
 if ( !is_singular() ) :
-    $arc_query = "SELECT DISTINCT YEAR(post_date) AS yyear, MONTH(post_date) AS mmonth FROM $wpdb->posts WHERE post_type = 'post' ORDER BY post_date DESC";
+    $arc_query = "SELECT DISTINCT YEAR(post_date) AS yyear, MONTH(post_date) AS mmonth FROM $wpdb->posts WHERE post_type = 'attachment' ORDER BY post_date DESC";
 
     $arc_result = $wpdb->get_results( $arc_query );