Page 1 of 1

Pagination for multiple criteria search

Posted: Mon Mar 21, 2011 2:14 am
by lala
Is there any samples code for pagination for multiple criteria search?
For example, allow 20records displayed in 1page, then next 20records in second page.
Anyone can help me? Thanks :bow:

Re: Page Split for Table

Posted: Mon Mar 21, 2011 7:41 am
by divedj
Search for "php mysql pagination tutorial" on google. There are lots of good ready made tutorials with good code explanations found already on the first search results.

Re: Page Split for Table

Posted: Mon Mar 21, 2011 10:12 am
by lala
divedj wrote:Search for "php mysql pagination tutorial" on google. There are lots of good ready made tutorials with good code explanations found already on the first search results.
Yea, I did search it.. I have some problem in displaying join table record... It can calculate how many page but cant show the result out.. I dont know what is the problem yet

Re: Page Split for Table

Posted: Mon Mar 21, 2011 11:04 am
by litebearer
Its easier for people to help if you show your code and describe the problem/errors you are experiencing

Re: Page Split for Table

Posted: Sat Mar 26, 2011 5:56 am
by lala
Is it possible to do pagination for multiple criteria search table?

Re: Pagination for multiple criteria search

Posted: Sat Mar 26, 2011 10:18 am
by litebearer
pagination handles the results of a query. It is the design of your query that is the real issue. Try combining the query into one
ie where (field01 like needle01 AND field02 LIKE needle02) OR field02 LIKE needle01

Re: Pagination for multiple criteria search

Posted: Sun Mar 27, 2011 10:58 am
by lala
litebearer wrote:pagination handles the results of a query. It is the design of your query that is the real issue. Try combining the query into one
ie where (field01 like needle01 AND field02 LIKE needle02) OR field02 LIKE needle01
hi litebearer,
I can do pagination for static query and query for multiple search query separately.. But I fail to combine both of it because what pagination that I did is call from other pages. Do u hv any sample dat show the both of its function. Thanks :)

Re: Pagination for multiple criteria search

Posted: Sun Mar 27, 2011 3:13 pm
by litebearer
Please show us what you have tried thus far.