There's a dollar(sign) in variable name

Something else to consider is that you can alias the column name in your select statement, like this:

PHP Code:

// Although I don't recommend adding '*' in the array, 
// I've done so here because I don't know what else you 
// may be selecting in this query.
$this->db->select(array('price_in_u$ as price_in_us', '*'));
// ...
echo "Price in US: {$comp_prod->price_in_us}"; 


Bonfire

Practical CodeIgniter 3
CodeIgniter Testing Guide