Page 1 of 1
number of records per page
Posted: Thu Aug 17, 2006 4:26 am
by shiranwas
hi,
I am having a problam with my displaying the records. i.e when i query a table it gives me all the records that matches my criterias but i want to show only 10 records in first pager and so on how to do this
please help me
shiran
Posted: Thu Aug 17, 2006 4:26 am
by JayBird
put
at the end of your query
Posted: Thu Aug 17, 2006 4:36 am
by Oren
Actually, you will need to use this for the first page:
Second page:
Third page:
And so on...
Posted: Thu Aug 17, 2006 4:41 am
by shiranwas
hi,
yes i did that but the thing is when i go to the next page i put limit 10 offset 10, and how do i go to previous
first page
select * from tblComplaints limit 10;
second and 3 ......
select * from tblComplaints limit 10 offset 10;
but how to go back to from 2nd page to first page
Posted: Thu Aug 17, 2006 4:42 am
by Oren
I don't understand what you mean

Posted: Thu Aug 17, 2006 5:05 am
by shiranwas
Oren,
i am very sorry i did not see your answer before i send earlier meaasage
what you sent is correct and working as the way i want.
thank you
Posted: Thu Aug 17, 2006 5:07 am
by Oren
Cool

Posted: Thu Aug 17, 2006 5:48 am
by Jenk
If you still have problems, search the forum for 'pagination'
should be plenty of topics to help you along
