summaryrefslogtreecommitdiffstats
path: root/frontends/php/include/db.inc.php
diff options
context:
space:
mode:
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;