Changeset 896 for trunk/include/category_calendar.inc.php

Timestamp:

Oct 17, 2005, 11:11:19 PM (19 years ago)

Author:

plg

Message:

• bug 154 fixed: "Calendar category, too precise dates". Bug came from the bigger precision of creation_date and available_date in images tables. Need to retrieve only the year-month-day information.

File:

• trunk/include/category_calendar.inc.php (modified) (1 diff)

trunk/include/category_calendar.inc.php

@@ -158 +158 @@
   // the number of picture for this day : $calendar_days
   $query = '
-SELECT DISTINCT('.$conf['calendar_datefield'].') AS day, COUNT(id) AS count
+SELECT
+    DISTINCT DATE_FORMAT('.$conf['calendar_datefield'].', \'%Y-%m-%d\') AS day
+  , COUNT(id) AS count
   FROM '.IMAGES_TABLE.' INNER JOIN '.IMAGE_CATEGORY_TABLE.' ON id = image_id
   '.$page['where'].'