[eluser]jonyork[/eluser]
Alright, if I run an sql query in phpmyadmin looking like this I get my desired value
Code:
SELECT `company` FROM `user` WHERE `username` = 'jonathan'
However, ive been hitting my head on the table. this is my CI code
Code:
$this->db->select('company');
$this->db->where('username', 'jonathan');
$company = $this->db->get('user');
and this is the subsequent print_r output
Code:
CI_DB_mysql_result Object ( [conn_id] => Resource id #28 [result_id] => Resource id #33 [result_array] => Array ( ) [result_object] => Array ( ) [current_row] => 0 [num_rows] => 1 [row_data] => )
help is greatly appreciated