Troubleshooting my SQL query

[eluser]jonyork[/eluser]
Awesome! Thank you for all your help. Might have a few more questions in the next few days, but so far, im really liking CI. Theres a learning curve for sure, but it does seem to help out in the long run.

heres the final code

Code:

<?php

$this->db->select('company')->from('user')->where('username', 'jonathan');
$user = $this->db->get();
$company = $user->row();
            
echo $company->company;

?>