Active Record and SQL error

[eluser]richie123[/eluser]
@nzmike: no, it different! $offset = 0 mean I query from the begining of a rows set

for example:
select * from user limit 0, 1 -> get 1st row
select * from user limit 1, 1 -> get 2nd row ...

I try this

Code:

if($offset!='')
   $this->db->limit(1, $offset);            
$query = $this->db->get('user');

but get the same result