diff options
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; |
