clear active record

[eluser]Cesar Kohl[/eluser]
I didn't understand your example, so I'll use another one:

Code in controller:

Code:

//Assume there is a table with 4 rows: id, phrase, tags, id_author
        echo '<pre>';
        
        //Selects the row 'phrase' with 'id=24' on table 'phrases'
        $this->db->select('phrase');
        $this->db->where('id',24);
        $contact1 = $this->db->get('phrases');
        
        print_r($contact1->row_array());
        
        
        //Selects rows 'id' and 'phrase' with 'id=24' on table 'phrases'
        $this->db->select('id,phrase');
        $this->db->where('id',24);
        $contact2 = $this->db->get('phrases');
        
        print_r($contact2->row_array());
        
        
        //Selects all rows with 'id=24' on table 'phrases'
        $this->db->select('');//this line can be deleted
        $this->db->where('id',24);
        $contact3 = $this->db->get('phrases');
        
        print_r($contact3->row_array());

Output in browser:

Array
(

[phrase] => The truth is you don't know what is going to happen tomorrow. Life is a crazy ride, and nothing is guaranteed.
)

Array
(

[id] => 24
[phrase] => The truth is you don't know what is going to happen tomorrow. Life is a crazy ride, and nothing is guaranteed.
)

Array
(

[id] => 24
[phrase] => The truth is you don't know what is going to happen tomorrow. Life is a crazy ride, and nothing is guaranteed.
[tags] => truth life
[id_author] => 22
)

Any questions?