From 6ddb5a17ae1a0a75ca75f846dbb7d3a98f1902a3 Mon Sep 17 00:00:00 2001 From: Derek Allard Date: Tue, 18 Dec 2007 17:22:50 +0000 Subject: Added 'random' as an order_by() option in Active Record. --- user_guide/database/active_record.html | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'user_guide/database/active_record.html') diff --git a/user_guide/database/active_record.html b/user_guide/database/active_record.html index d608459e4..739d56a15 100644 --- a/user_guide/database/active_record.html +++ b/user_guide/database/active_record.html @@ -353,7 +353,7 @@ $this->db->or_like('body', $match);

$this->db->order_by();

Lets you set an ORDER BY clause. The first parameter contains the name of the column you would like to order by. -The second parameter lets you set the direction of the result. Options are asc or desc

+The second parameter lets you set the direction of the result. Options are asc or desc, or random.

$this->db->order_by("title", "desc");
@@ -375,6 +375,7 @@ The second parameter lets you set the direction of the result. Options are

Note: order_by() was formerly known as orderby(), which has been deprecated.

+

Note: random ordering is not currently supported in Orcacle or MSSQL drivers.

$this->db->limit();

Lets you limit the number of rows you would like returned by the query:

-- cgit v1.2.3-24-g4f1b