From c93ab2a21f816469f4fc0d9454e391fc29a9e59c Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Sat, 9 Nov 2002 20:02:41 +0000
Subject: - Added a db_query_range function.  Patch by Natrak, slightly
 modified.

---
 includes/database.mysql.inc | 32 ++++++++++++++++++++++++++++++++
 includes/database.pear.inc  | 18 +++++++++++++++++-
 2 files changed, 49 insertions(+), 1 deletion(-)

(limited to 'includes')

diff --git a/includes/database.mysql.inc b/includes/database.mysql.inc
index 62e87f778..e3bd26d42 100644
--- a/includes/database.mysql.inc
+++ b/includes/database.mysql.inc
@@ -117,4 +117,36 @@ function db_affected_rows() {
   return mysql_affected_rows();
 }
 
+/**
+ * Generates a limited query
+ *
+ * @param string  $query query
+ * @param integer $from  the row to start to fetching
+ * @param integer $count the numbers of rows to fetch
+ *
+ * @return mixed a DB_Result object or a DB_Error
+ *
+ * @access public
+ */
+function db_query_range($query, $from, $count) {
+  $query .= " LIMIT $from, $count";
+  // TODO: debug version
+  return db_query($query);
+}
+
+/**
+ * Generates a limited query
+ *
+ * @param string  $query query
+ * @param integer $from  the row to start to fetching
+ * @param integer $count the numbers of rows to fetch
+ *
+ * @access public
+ */
+function db_query_range($query, $from, $count) {
+  $query .= " LIMIT $from, $count";
+  // TODO: debug version
+  return db_query($query);
+}
+
 ?>
\ No newline at end of file
diff --git a/includes/database.pear.inc b/includes/database.pear.inc
index d404f1002..0c2c72f4d 100644
--- a/includes/database.pear.inc
+++ b/includes/database.pear.inc
@@ -112,4 +112,20 @@ function db_affected_rows() {
   return $db_handle->affectedRows();
 }
 
-?>
\ No newline at end of file
+/**
+ * Generates a limited query
+ *
+ * @param string  $query query
+ * @param integer $from  the row to start to fetching
+ * @param integer $count the numbers of rows to fetch
+ *
+ * @return mixed a DB_Result object or a DB_Error
+ *
+ * @access public
+ */
+
+function db_query_range($query, $from, $count) {
+  return DB::limitQuery($query, $from, $count);
+}
+
+?>
-- 
cgit v1.2.3