From d23332dbc5dabb29dfec400d2d9ba782b46b5615 Mon Sep 17 00:00:00 2001 From: osmiy Date: Wed, 25 Oct 2006 07:21:56 +0000 Subject: - developed node manager (Eugene) git-svn-id: svn://svn.zabbix.com/trunk@3379 97f52cf1-0a1b-0410-bd0e-c28be96e8082 --- frontends/php/include/db.inc.php | 29 +++++++++++++++-------------- 1 file changed, 15 insertions(+), 14 deletions(-) (limited to 'frontends/php/include/db.inc.php') diff --git a/frontends/php/include/db.inc.php b/frontends/php/include/db.inc.php index 5bbd8952..0304d867 100644 --- a/frontends/php/include/db.inc.php +++ b/frontends/php/include/db.inc.php @@ -64,20 +64,6 @@ } } - /* NOTE: - LIMIT and OFFSET records - - Example: select 6-15 row. - - MySQL: - SELECT a FROM tbl LIMIT 5,10 - SELECT a FROM tbl LIMIT 10 OFFSET 5 - PostgreSQL: - SELECT a FROM tbl LIMIT 10 OFFSET 5 - Oracle: - SELECT a FROM tbe WHERE ROWNUM < 15 // ONLY < 15 - SELECT * FROM (SELECT ROWNUM as RN, * FROM tbl) WHERE RN BETWEEN 6 AND 15 - */ function DBstart() { @@ -98,6 +84,21 @@ } } + /* NOTE: + LIMIT and OFFSET records + + Example: select 6-15 row. + + MySQL: + SELECT a FROM tbl LIMIT 5,10 + SELECT a FROM tbl LIMIT 10 OFFSET 5 + PostgreSQL: + SELECT a FROM tbl LIMIT 10 OFFSET 5 + Oracle: + SELECT a FROM tbe WHERE ROWNUM < 15 // ONLY < 15 + SELECT * FROM (SELECT ROWNUM as RN, * FROM tbl) WHERE RN BETWEEN 6 AND 15 + */ + function DBselect($query, $limit='NO') { global $DB,$DB_TYPE; -- cgit