From 7f4d2f1f67bdab32137ecc2cc827158d7770980b Mon Sep 17 00:00:00 2001 From: Derek Allard Date: Thu, 26 Jun 2008 16:34:46 +0000 Subject: fix up where_in examples --- user_guide/database/active_record.html | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'user_guide') diff --git a/user_guide/database/active_record.html b/user_guide/database/active_record.html index aaee21e97..a42f9c03f 100644 --- a/user_guide/database/active_record.html +++ b/user_guide/database/active_record.html @@ -282,28 +282,28 @@ $this->db->or_where('id >', $id);

$names = array('Frank', 'Todd', 'James');
$this->db->where_in('username', $names);
- // Produces: AND WHERE username IN ('Frank', 'Todd', 'James')

+ // Produces: WHERE username IN ('Frank', 'Todd', 'James')

$this->db->or_where_in();

Generates a WHERE field IN ('item', 'item') SQL query joined with OR if appropriate

$names = array('Frank', 'Todd', 'James');
$this->db->or_where_in('username', $names);
- // Produces: OR WHERE username IN ('Frank', 'Todd', 'James')

+ // Produces: OR username IN ('Frank', 'Todd', 'James')

$this->db->where_not_in();

Generates a WHERE field NOT IN ('item', 'item') SQL query joined with AND if appropriate

$names = array('Frank', 'Todd', 'James');
$this->db->where_not_in('username', $names);
- // Produces: AND WHERE username NOT IN ('Frank', 'Todd', 'James')

+ // Produces: WHERE username NOT IN ('Frank', 'Todd', 'James')

$this->db->or_where_not_in();

Generates a WHERE field NOT IN ('item', 'item') SQL query joined with OR if appropriate

$names = array('Frank', 'Todd', 'James');
$this->db->or_where_not_in('username', $names);
- // Produces: OR WHERE username NOT IN ('Frank', 'Todd', 'James')

+ // Produces: OR username NOT IN ('Frank', 'Todd', 'James')

$this->db->like();

This function enables you to generate LIKE clauses, useful for doing searches.

-- cgit v1.2.3-24-g4f1b