Added the ability to pass an array of tables to the delete() statement in Active Record.

2 files changed, 11 insertions, 8 deletions

diff --git a/user_guide/changelog.html b/user_guide/changelog.html
index 033824b56..3fbac474a 100644
--- a/user_guide/changelog.html
+++ b/user_guide/changelog.html
@@ -70,6 +70,7 @@ Change Log
     <li>Added 'random' as an <kbd>order_by()</kbd> option in <a href="./database/active_record.html">Active Record</a>.</li>

     <li>Added <kbd>where_in()</kbd>, <kbd>where_in_or()</kbd>, <kbd>where_not_in()</kbd>, and <kbd>where_not_in_or()</kbd> to <a href="./database/active_record.html">Active Record</a>.</li>

     <li>Added support for <kbd>limit()</kbd> into <kbd>update()</kbd> and <kbd>delete()</kbd> statements in  <a href="./database/active_record.html">Active Record</a>.</li>

+    <li>Added the ability to pass an array of tables to the <kbd>delete()</kbd> statement in <a href="./database/active_record.html">Active Record</a>.</li>

     <li>Added titles to all user manual pages.</li>

     <li>Added a check for NULL fields in the MySQL database backup utility.</li>

     <li>Documented the <kbd>timezones()</kbd> function in the <a href="./helpers/date_helper.html">Date Helper</a>.</li>

diff --git a/user_guide/database/active_record.html b/user_guide/database/active_record.html
index d938b5dff..e7c823fde 100644
--- a/user_guide/database/active_record.html
+++ b/user_guide/database/active_record.html
@@ -623,14 +623,16 @@ $this->db->delete('mytable', array('id' => $id));
 <p>The first parameter is the table name, the second is the where clause. You can also use the <dfn>where()</dfn> or <dfn>or_where()</dfn> functions instead of passing

 the data to the second parameter of the function:</p>

 

-<code>

-$this->db->where('id', $id);<br />

-$this->db->delete('mytable');

-<br /><br />

-// Produces:<br />

-// DELETE FROM mytable <br />

-// WHERE id = $id</code>

-

+<p><code> $this->db->where('id', $id);<br />

+    $this->db->delete('mytable'); <br />

+    <br />

+    // Produces:<br />

+    // DELETE FROM mytable <br />

+    // WHERE id = $id</code></p>

+<p>An array of table names can be passed into delete() if you would like to delete data from more then 1 table.</p>

+<p><code>$tables = array('table1', 'table2', 'table3');<br />

+$this-&gt;db-&gt;where('id', '5');<br />

+$this-&gt;db-&gt;delete($tables);</code></p>

 <p class="important"><strong>Note:</strong> All values are escaped automatically producing safer queries.</p>