commit c644128fdd49a47d791240e0e38b54cd22412bc5
author Derek Allard <derek.allard@ellislab.com> Wed Jul 04 23:54:32 2007 +0000
committer Derek Allard <derek.allard@ellislab.com> Wed Jul 04 23:54:32 2007 +0000
tree fd2135d295c103395f5d0bd89056b0e798cfcdb3
parent 691010e72ec7fb4a05740332a10b5f046a82c666

fixed validation errors... about a zillion of em.

user_guide/database/queries.html

diff --git a/user_guide/database/queries.html b/user_guide/database/queries.html
index e55a532..013d64f 100644
--- a/user_guide/database/queries.html
+++ b/user_guide/database/queries.html
@@ -95,15 +95,13 @@
 <li><strong>$this->db->escape()</strong> This function determines the data type so that it

 can escape only string data.  It also automatically adds single quotes around the data so you don't have to:

 

-<code>$sql = "INSERT INTO table (title) VALUES(".$this->db->escape($title).")";</code>

+<code>$sql = "INSERT INTO table (title) VALUES(".$this->db->escape($title).")";</code></li>

 

 

 <li><strong>$this->db->escape_str()</strong>  This function escapes the data passed to it, regardless of type.

 Most of the time you'll use the above function rather then this one. Use the function like this:

 

-<code>$sql = "INSERT INTO table (title) VALUES('".$this->db->escape_str($title)."')";</code>

-

-</li>

+<code>$sql = "INSERT INTO table (title) VALUES('".$this->db->escape_str($title)."')";</code></li>

 </ol>

 

 

@@ -134,7 +132,7 @@
 <a href="#top">Top of Page</a>&nbsp;&nbsp;&nbsp;&middot;&nbsp;&nbsp;

 <a href="../index.html">User Guide Home</a>&nbsp;&nbsp;&nbsp;&middot;&nbsp;&nbsp;

 Next Topic:&nbsp;&nbsp;<a href="results.html">Query Results</a>

-<p>

+</p>

 <p><a href="http://www.codeigniter.com">CodeIgniter</a> &nbsp;&middot;&nbsp; Copyright &#169; 2007 &nbsp;&middot;&nbsp; <a href="http://ellislab.com/">Ellislab, Inc.</a></p>

 </div>