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

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.