Variable in Query?

[eluser]ejangi[/eluser]
You can also use query-bindings, which takes care of escaping as well - though in this instance (because we're casting) it's probably overkill:

Code:

$query = $this->db->query('SELECT * FROM pages WHERE pageID = ?', array((int) $id));