sql shorthand not working for me

[eluser]guillermo, out of repose[/eluser]
[pre]
function get_product_by_id($id)
{
$this->db->select('*')->from('product')->where('id', $id);
$query = $this->db->get();
return $query->result();
}
[/pre]