From 30f89d683335c0bfbe4d2a6b28ad4c3fba7728a9 Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Sun, 27 Apr 2003 06:18:03 +0000
Subject: [PATCH] New delete_records_select() function

---
 lib/datalib.php | 13 +++++++++++++
 1 file changed, 13 insertions(+)

diff --git a/lib/datalib.php b/lib/datalib.php
index 427540f7c8..a7955c8a81 100644
--- a/lib/datalib.php
+++ b/lib/datalib.php
@@ -542,6 +542,19 @@ function delete_records($table, $field1="", $value1="", $field2="", $value2="",
     return $db->Execute("DELETE FROM $CFG->prefix$table $select");
 }
 
+function delete_records_select($table, $select="") {
+/// Delete one or more records from a table
+/// "select" is a fragment of SQL to define the selection criteria
+
+    global $CFG, $db;
+
+    if ($select) {
+        $select = "WHERE $select";
+    }
+
+    return $db->Execute("DELETE FROM $CFG->prefix$table $select");
+}
+
 
 function insert_record($table, $dataobject, $returnid=true) {
 /// Insert a record into a table and return the "id" field if required
-- 
2.39.5