added DB LIMIT abstraction

git-svn-id: https://svn.roundcube.net/trunk@47 208e9e7b-5314-0410-a742-e7e81cd9613c

1 files changed, 3 insertions, 4 deletions

diff --git a/roundcubemail/program/steps/addressbook/func.inc b/roundcubemail/program/steps/addressbook/func.inc
index 7858a4e88..53628162b 100644
--- a/roundcubemail/program/steps/addressbook/func.inc
+++ b/roundcubemail/program/steps/addressbook/func.inc
@@ -59,12 +59,11 @@ function rcmail_contacts_list($attrib)
     $sql_result = $DB->query(sprintf("SELECT * FROM %s
                                       WHERE  del!='1'
                                       AND    user_id=%d
-                                      ORDER BY name
-                                      LIMIT %d, %d",
+                                      ORDER BY name",
                                      get_table_name('contacts'),
-                                     $_SESSION['user_id'],
+                                     $_SESSION['user_id']),
                                      $start_row,
-                                     $CONFIG['pagesize']));
+                                     $CONFIG['pagesize']);
     }
   else
     $sql_result = NULL;