From fcda6671f3021273844f7898c7cfec1e99df8ec2 Mon Sep 17 00:00:00 2001
From: Dan McGee <dan@archlinux.org>
Date: Mon, 25 Apr 2011 23:23:00 -0500
Subject: 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>
---
 web/lib/pkgfuncs.inc | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'web/lib/pkgfuncs.inc')

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;
-- 
cgit v1.2.3-24-g4f1b