Re: Search and Split the table into PAGES

I've found with slow queries like that one the best way to handle it is to load up an array worth of all the results and build the pages around that, rather then trying to count() and limit (which for fine for fast queries) I G wrote: > > hi i am trying to do something wacky but i am not able to figure it out > HOWTO what i > am doing is like when a user searches for a %$keyword% my application > searches for > that %$keyword% and displays all the possible result on the same page > but what I > really want is, it should display only first 20 result and rest should > automatically diverted > to next page and at the end it will say next 20 result and so on... is > it possible to do > something like that…. while the whole application in on one single > page..... > please help or please explain how to or is there anything anyone had > already tried… from where I can refer like or something like that… > > _________________________________________________________ > > Do You Yahoo!? > > Get your free @yahoo.com address at http://mail.yahoo.com > > -- > --------------------------------------------------------------------- > Please check "http://www.mysql.com/php/manual.php" > before > posting. To request this thread, e-mail mysql-thread50304@lists.mysql.com > > To unsubscribe, send a message to: > <mysql-unsubscribe-cfaber=fpsn.net@lists.mysql.com> > > If you have a broken mail client that cannot send a message to the above address(Microsoft > Outlook), you can use http://lists.mysql.com/php/unsubscribe.php