summaryrefslogtreecommitdiffstats
path: root/frontends/php/include/db.inc.php
diff options
context:
space:
mode:
authorosmiy <osmiy@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2006-10-25 07:21:56 +0000
committerosmiy <osmiy@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2006-10-25 07:21:56 +0000
commitd23332dbc5dabb29dfec400d2d9ba782b46b5615 (patch)
tree21d5823c2940c9ada032bc3650fac8423b266365 /frontends/php/include/db.inc.php
parent28a09ed13e41ddbe5e30d63e92a1f5fb3395ef89 (diff)
downloadzabbix-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.php29
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;