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

Code: Select all

LIMIT 10
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:

Code: Select all

LIMIT 0, 10
Second page:

Code: Select all

LIMIT 10, 10
Third page:

Code: Select all

LIMIT 20, 10
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 8)

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 :)