Changeset 136

Timestamp:

05/31/2007 11:29:35 AM (18 months ago)

Author:

Shadowhand

Message:

Fixing the docs for #33

Changed files:
user_guide/database/active_record.html

Files:

• trunk/user_guide/database/active_record.html (modified) (4 diffs)

trunk/user_guide/database/active_record.html

@@ -87 +87 @@
 </ul>
 
-
-
-
 <a name="select">&nbsp;</a>
 <h1>Selecting Data</h1>
@@ -97 +94 @@
 <p><strong>Note: If you are using PHP 5 you can use method chaining for more compact syntax. This is described at the end of the page.</strong></p>
 
-
 <h2>$this->db->get();</h2>
 
@@ -111 +107 @@
 <br />
 // Produces: SELECT * FROM mytable LIMIT 20, 10 (in MySQL. Other databases have slightly different syntax)</code>
-
-
 
 <p>You'll notice that the above function is assigned to a variable named <kbd>$query</kbd>, which can be used to show the results:</p>
@@ -395 +389 @@
 
 
-
-        
+<h2>$this->db->count_records();</h2>
+
+<p>Permits you to determine the number of rows in a particular query, without actually making the query. Submit the table name
+in the first parameter. Example:</p>
+
+<code>$this->db->where('<var>some_field</var>', 20);<br />
+$this->db->count_records('<var>my_table</var>');
+<br />
+// Produces an integer, like 10</code>
+
+<p class="important"><strong>Note:</strong> This function differs from <kbd>count_all</kbd> in that it allows you to use
+<kbd>where</kbd> before counting the rows.</p>
+
+
 <a name="insert">&nbsp;</a>
 <h1>Inserting Data</h1>