Documented distinct() in Active Record.

2 files changed, 9 insertions, 1 deletions

diff --git a/user_guide/changelog.html b/user_guide/changelog.html
index b28ec8c46..8fa74a13b 100644
--- a/user_guide/changelog.html
+++ b/user_guide/changelog.html
@@ -75,6 +75,7 @@ Change Log
     <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>

     <li>Documented unset_userdata in the <a href="./libraries/sessions.html">Session class</a>.</li>

+    <li>Documented <kbd>distinct()</kbd> in <a href="./database/active_record.html">Active Record</a>. </li>

     <li>Changed the behaviour of custom callbacks so that they no longer trigger the &quot;required&quot; rule. </li>

     <li>Added a few additional mime type variations for CSV.</li>

     <li>Added <kbd>strip_quotes()</kbd> function to <a href="./helpers/string_helper.html">string helper</a>.</li>

diff --git a/user_guide/database/active_record.html b/user_guide/database/active_record.html
index e7c823fde..d43101642 100644
--- a/user_guide/database/active_record.html
+++ b/user_guide/database/active_record.html
@@ -370,8 +370,15 @@ $this-&gt;db-&gt;or_not_like('body', 'match'); <br />
 <br />

 <br />// Produces: GROUP BY title, date</code>

 	

-		

 <p class="important">Note: group_by() was formerly known as groupby(), which has been deprecated. </p>

+

+<h2> $this-&gt;db-&gt;distinct();<br />

+</h2>

+<p>Adds the &quot;DISTINCT&quot; keyword to to a query</p>

+<p><code>$this-&gt;db-&gt;distinct();<br />

+    $this-&gt;db-&gt;get('table');<br />

+        <br />

+    // Produces: SELECT DISTINCT * FROM table</code></p>

 <h2>$this->db->having();</h2>

 <p>Permits you to write the HAVING portion of your query:</p>