Re: I need do paging in php, I use ODBC Access

* Jochem Maas <jochem@iamjochem.com> : > Richard Lynch wrote: > > On Thu, April 21, 2005 12:23 pm, Warren Vail said: > > > > > The only approach left that I could come up with is to transfer the > > > entire sequence set to your application, and count the rows, perhaps > > > only displaying the rows you want to show. This is obviously not very > > > efficient (in fact, with enough rows it may prove impossible because of > > > memory limitations), but it will produce what appears to be a paged > > > result. > > > > If this is the best answer your database software will let you come up > > with, it's time to switch databases :-) > > > > Fortunately, the databases that don't do "LIMIT" have this nifty thing > > I was under the impression that LIMIT was mySQL specific (although its > quite likely that their use of the keyword and the ubiqitous nature of mySQL > that other vendors have also adopted it. Actually, LIMIT is in ANSI SQL. -- Matthew Weier O'Phinney | WEBSITES: Webmaster and IT Specialist | http://www.garden.org National Gardening Association | http://www.kidsgardening.com 802-863-5251 x156 | http://nationalgardenmonth.org mailto:matthew@garden.org | http://vermontbotanical.org