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/acctfuncs.inc | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

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

diff --git a/web/lib/acctfuncs.inc b/web/lib/acctfuncs.inc
index fe1cfb1..8e2ecb3 100644
--- a/web/lib/acctfuncs.inc
+++ b/web/lib/acctfuncs.inc
@@ -405,7 +405,7 @@ function search_results_page($UTYPE,$O=0,$SB="",$U="",$T="",
 			break;
 	}
 	$search_vars[] = "SB";
-	$q.= "LIMIT ". $OFFSET . ", " . $HITS_PER_PAGE;
+	$q.= "LIMIT " . $HITS_PER_PAGE . " OFFSET " . $OFFSET;
 
 	$dbh = db_connect();
 
-- 
cgit v1.2.3-70-g09d2