From 5808346898ec9c602893fc54540958a8c556be29 Mon Sep 17 00:00:00 2001 From: admin Date: Sun, 24 Sep 2006 17:58:27 +0000 Subject: --- user_guide/libraries/database/helpers.html | 15 --------------- user_guide/libraries/database/results.html | 27 +++++++++++++++++++++++++-- 2 files changed, 25 insertions(+), 17 deletions(-) (limited to 'user_guide/libraries') diff --git a/user_guide/libraries/database/helpers.html b/user_guide/libraries/database/helpers.html index dd05aef4c..0d299c023 100644 --- a/user_guide/libraries/database/helpers.html +++ b/user_guide/libraries/database/helpers.html @@ -67,21 +67,6 @@ Query Helpers

Query Helper Functions

-

$query->num_rows()

-

The number of rows returned by the query. Note: In this example, $query is the variable that the query result object is assigned to:

- -$query = $this->db->query('SELECT * FROM my_table');

-echo $query->num_rows(); -
- -

$query->num_fields()

-

The number of FIELDS returned by the query. Make sure to call the function using your query result object:

- -$query = $this->db->query('SELECT * FROM my_table');

-echo $query->num_fields(); -
- -

$this->db->insert_id()

The insert ID number when performing database inserts.

diff --git a/user_guide/libraries/database/results.html b/user_guide/libraries/database/results.html index 342e7e4b4..b1952db5a 100644 --- a/user_guide/libraries/database/results.html +++ b/user_guide/libraries/database/results.html @@ -100,7 +100,7 @@ Query Results    }
} - +

result_array()

This function returns the query result as a pure array, or FALSE on failure. Typically you'll use this in a foreach loop, like this:

@@ -114,6 +114,10 @@ Query Results    echo $row['body'];
} +

result('array')

+ +

Identical to $this->db->result_array().

+

row()

@@ -180,6 +184,25 @@ Query Results +


Result Helper Functions

+ + +

$query->num_rows()

+

The number of rows returned by the query. Note: In this example, $query is the variable that the query result object is assigned to:

+ +$query = $this->db->query('SELECT * FROM my_table');

+echo $query->num_rows(); +
+ +

$query->num_fields()

+

The number of FIELDS (columns) returned by the query. Make sure to call the function using your query result object:

+ +$query = $this->db->query('SELECT * FROM my_table');

+echo $query->num_fields(); +
+ + + @@ -192,7 +215,7 @@ Previous Topic:  Queries    ·   Top of Page   ·   User Guide Home   ·   -Next Topic:  Active Record Pattern +Next Topic:  Query Helper Functions

Code Igniter  ·  Copyright © 2006  ·  pMachine, Inc.

-- cgit v1.2.3-24-g4f1b