[eluser]InsiteFX[/eluser]
1) first name, last name and email
Code:
function retrieve()
{
$this->db->where('email_address', $this->input->post('email_address')); //validate username
$q = $this->db->get('membership');
if($q->num_rows() > 0) {
// return a single db row array $row['name'];
return $q->row_array();
// return a single db object $row->name;
// return $q->row;
}
return FALSE;
}
}
2) Using the query above you already have the first_name
Code:
$data = $this->model_name->retrive();
// array
$first_name = $data['first_name'];
// object
$first_name = $data->first_name;