offset not working , want to do paging
- by Rahul Mehta
Hi,
i have tried offset in simpledb but its not working as it working in mysql , and i want to do paging for my database api in php so that i send the pagenumber and pagelength to the query and it will return the data of that page only.
How this i can do in simpledb.
select * from second
where time_stamp is not null and gibid = '54' and gibview = 'O'
order by time_stamp asc limit $pagelength
as offset is not working so i can't add offset in query.
I have google and find there is next token is returned but i am not getting nexttoken.
how to check for nexttoken.
Please help .
Thanks