Variable in a SQL Query

[eluser]Rick Jolly[/eluser]
Always make sure your values are escaped. Query bindings do that for you and it's cleaner:

Code:

$this->db->query('SELECT entry.id, city.*, country.* FROM entry, city WHERE  city.country = ?', array($country));