Hi

Iam new to code igniter technique. Got a problem relating to retrieving fields from database.

According to the logic, I query database for desired/selected field results and send them to any page view. In a normal way the array of results ,have same names as database field names. So printing the array as $row->Name(field). In a way its working fine,but....

The problem is that, when any field is empty , its gives error Undefined index

Can you post more code so we can get a better idea of what's happening?

But from what you gave....field should probably have a $ sign...unless it's a constant, and you should probably do constant("field");

The coding is simple, I mentioned field, just to specify that Name is field of table.

The model code is

data_query (model name) and function fetch_profile($id):

$this->db->select('*')->where('Id',$id)->from('location');
$query = $this->db->get()->row_array();
return $query;

The controller code is

$this->load->model('data_query');
$page['result'] = $this->data_query->fetch_profile($id);
$this->load->view('Profile',$page);

And displaying the result

echo $result['Name'];
echo $result['Address']; etc etc

Its working fine, if the fields are not empty ,but gives error (undefined index) for empty field. Kindly need a solution.

Got it cleared.

Thanks, anyway.