How can I get a SET command work in CI?
$sql = 'SET @rownum := 0; SELECT @rownum := @rownum+1 AS rownum, EquipmentID, EquipmentType FROM Equipment';
$query = $this->db->query($sql);
foreach ($query-result() as $row)
{
echo $row->rownum; // this will not exist???
}