Changeset 4331 for trunk/include/functions_notification.inc.php

Timestamp:

Nov 21, 2009, 1:15:22 PM (14 years ago)

Author:

nikrou

Message:

Feature 1255 : improve sql
Replace in queries LIMIT N,M by LIMIT N OFFSET M

File:

• trunk/include/functions_notification.inc.php (modified) (3 diffs)

trunk/include/functions_notification.inc.php

@@ -445 +445 @@
   GROUP BY date_available
   ORDER BY date_available DESC
-  LIMIT 0,'.$max_dates.'
+  LIMIT 0 OFFSET '.$max_dates.'
 ;';
   $result = pwg_query($query);
@@ -465 +465 @@
     AND tn_ext IS NOT NULL
   ORDER BY RAND(NOW())
-  LIMIT 0,'.$max_elements.'
+  LIMIT 0 OFFSET '.$max_elements.'
 ;';
       $dates[$i]['elements'] = array();
@@ -485 +485 @@
   GROUP BY category_id
   ORDER BY img_count DESC
-  LIMIT 0,'.$max_cats.'
+  LIMIT 0 OFFSET '.$max_cats.'
 ;';
       $dates[$i]['categories'] = array();