diff options
| author | osmiy <osmiy@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2006-10-25 07:21:56 +0000 |
|---|---|---|
| committer | osmiy <osmiy@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2006-10-25 07:21:56 +0000 |
| commit | d23332dbc5dabb29dfec400d2d9ba782b46b5615 (patch) | |
| tree | 21d5823c2940c9ada032bc3650fac8423b266365 /frontends/php/include/db.inc.php | |
| parent | 28a09ed13e41ddbe5e30d63e92a1f5fb3395ef89 (diff) | |
| download | zabbix-d23332dbc5dabb29dfec400d2d9ba782b46b5615.tar.gz zabbix-d23332dbc5dabb29dfec400d2d9ba782b46b5615.tar.xz zabbix-d23332dbc5dabb29dfec400d2d9ba782b46b5615.zip | |
- developed node manager (Eugene)
git-svn-id: svn://svn.zabbix.com/trunk@3379 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'frontends/php/include/db.inc.php')
| -rw-r--r-- | frontends/php/include/db.inc.php | 29 |
1 files changed, 15 insertions, 14 deletions
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; |
