From 297ac6ebd15bc53ce6c7d96b659b22fb3b220d74 Mon Sep 17 00:00:00 2001
From: Romain LE DISEZ <romain.git@ledisez.net>
Date: Tue, 23 Jun 2009 16:05:15 +0800
Subject: Improve compatibility with other RDBMS

Signed-off-by: Bharat Mediratta <bharat@menalto.com>
---
 modules/search/helpers/search.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'modules')

diff --git a/modules/search/helpers/search.php b/modules/search/helpers/search.php
index 15efa3b2..9046ad2d 100644
--- a/modules/search/helpers/search.php
+++ b/modules/search/helpers/search.php
@@ -45,7 +45,7 @@ class search_Core {
       "WHERE MATCH({search_records}.`data`) AGAINST ('$q' IN BOOLEAN MODE) " .
       $access_sql .
       "ORDER BY `score` DESC " .
-      "LIMIT $offset, $limit";
+      "LIMIT $limit OFFSET $offset";
 
     return array($count, new ORM_Iterator(ORM::factory("item"), $db->query($query)));
   }
-- 
cgit v1.2.3