diff options
author | Dan McGee <dan@archlinux.org> | 2011-04-26 06:23:00 +0200 |
---|---|---|
committer | Lukas Fleischer <archlinux@cryptocrack.de> | 2011-04-27 14:50:27 +0200 |
commit | fcda6671f3021273844f7898c7cfec1e99df8ec2 (patch) | |
tree | 51dd4ce96f95765f15d807de37e664497e164b71 /web/html/rss.php | |
parent | ed9c95623fcf3b46e42dfbb2596abbf4c55107a3 (diff) | |
download | aur-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/html/rss.php')
-rw-r--r-- | web/html/rss.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/web/html/rss.php b/web/html/rss.php index cb0bf40f..05478154 100644 --- a/web/html/rss.php +++ b/web/html/rss.php @@ -32,7 +32,7 @@ $rss->image = $image; $dbh = db_connect(); $q = "SELECT * FROM Packages "; $q.= "ORDER BY SubmittedTS DESC "; -$q.= "LIMIT 0 , 20"; +$q.= "LIMIT 20"; $result = db_query($q, $dbh); while ($row = mysql_fetch_assoc($result)) { |