diff options
author | GDmac <grdalenoort@gmail.com> | 2013-11-09 08:01:52 +0100 |
---|---|---|
committer | GDmac <grdalenoort@gmail.com> | 2013-11-09 08:01:52 +0100 |
commit | 01e9fb1d6aab8e513a9ebd786e9abff74d8b63ca (patch) | |
tree | a2e09ef9c8d118f769b9572764f997d0c296902a | |
parent | e1b8683d7983cca11219d618f093b842429bd41c (diff) |
docs: get_compile_select
get_compile_select(null,false) without reset also preserves LIMIT settings
-rw-r--r-- | user_guide_src/source/database/query_builder.rst | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/user_guide_src/source/database/query_builder.rst b/user_guide_src/source/database/query_builder.rst index 65609c1cb..5e0dcb4be 100644 --- a/user_guide_src/source/database/query_builder.rst +++ b/user_guide_src/source/database/query_builder.rst @@ -68,7 +68,7 @@ Example:: // Produces string: SELECT * FROM mytable The second parameter enables you to set whether or not the query builder query -will be reset (by default it will be—just like `$this->db->get()`):: +will be reset (by default it will be reset, just like when using `$this->db->get()`):: echo $this->db->limit(10,20)->get_compiled_select('mytable', FALSE); // Produces string: SELECT * FROM mytable LIMIT 20, 10 @@ -76,7 +76,7 @@ will be reset (by default it will be—just like `$this->db->get()`):: echo $this->db->select('title, content, date')->get_compiled_select(); - // Produces string: SELECT title, content, date FROM mytable + // Produces string: SELECT title, content, date FROM mytable LIMIT 20, 10 The key thing to notice in the above example is that the second query did not utilize `$this->db->from()`_ and did not pass a table name into the first @@ -1055,4 +1055,4 @@ run the query:: $data = $this->db->get()->result_array(); // Would execute and return an array of results of the following query: - // SELECT field1, field1 from mytable where field3 = 5;
\ No newline at end of file + // SELECT field1, field1 from mytable where field3 = 5; |