From f0d0a0952c9889323d60bec249df0fccf286d1a6 Mon Sep 17 00:00:00 2001
From: nikrou <nikrou@piwigo.org>
Date: Sat, 21 Nov 2009 12:15:22 +0000
Subject: Feature 1255 : improve sql Replace in queries LIMIT N,M by LIMIT N
 OFFSET M

git-svn-id: http://piwigo.org/svn/trunk@4331 68402e56-0260-453c-a942-63ccdbb3a9ee
---
 comments.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'comments.php')

diff --git a/comments.php b/comments.php
index 3300bc6aa..182f673a0 100644
--- a/comments.php
+++ b/comments.php
@@ -326,7 +326,7 @@ SELECT com.id AS comment_id
 if ('all' != $page['items_number'])
 {
   $query.= '
-  LIMIT '.$start.','.$page['items_number'];
+  LIMIT '.$start.' OFFSET '.$page['items_number'];
 }
 $query.= '
 ;';
-- 
cgit v1.2.3