Query for 1 variable from database table. Looking for optimized code.

[eluser]brandontran[/eluser]
I can get the variable 'country' from the database table,but it isn't very clean looking to me.

To all the code optimizers out there, what is the simplest way to get the variable country from this table?


$this->db_dash->select('country');
$this->db_dash->where('country_code', $country_code);
$query = $this->db_dash->get('country_table');
if ($query->num_rows() > 0)
{
$row = $query->row();
$country_title = $row->country;
}