summaryrefslogtreecommitdiffstats
path: root/web/lib/pkgfuncs.inc
diff options
context:
space:
mode:
authorDan McGee <dan@archlinux.org>2011-04-26 06:23:00 +0200
committerLukas Fleischer <archlinux@cryptocrack.de>2011-04-27 14:50:27 +0200
commitfcda6671f3021273844f7898c7cfec1e99df8ec2 (patch)
tree51dd4ce96f95765f15d807de37e664497e164b71 /web/lib/pkgfuncs.inc
parented9c95623fcf3b46e42dfbb2596abbf4c55107a3 (diff)
downloadaur-fcda6671f3021273844f7898c7cfec1e99df8ec2.tar.gz
aur-fcda6671f3021273844f7898c7cfec1e99df8ec2.tar.xz
SQL: use standard LIMIT/OFFSET syntax
Increases compatibility with standard SQL dialect. Thanks-to: elij <elij.mx@gmail.com> Signed-off-by: Dan McGee <dan@archlinux.org> Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Diffstat (limited to 'web/lib/pkgfuncs.inc')
-rw-r--r--web/lib/pkgfuncs.inc2
1 files changed, 1 insertions, 1 deletions
diff --git a/web/lib/pkgfuncs.inc b/web/lib/pkgfuncs.inc
index 8f90d0e3..7b43e45e 100644
--- a/web/lib/pkgfuncs.inc
+++ b/web/lib/pkgfuncs.inc
@@ -501,7 +501,7 @@ function pkg_search_page($SID="") {
break;
}
- $q_limit = "LIMIT ".$_GET["O"].", ".$_GET["PP"];
+ $q_limit = "LIMIT ".$_GET["PP"]." OFFSET ".$_GET["O"];
$q = $q_select . $q_from . $q_from_extra . $q_where . $q_sort . $q_limit;
$q_total = "SELECT COUNT(*) " . $q_from . $q_where;