Re: Limit items per page like in Altavista.

On 31 Aug, Maxim Maletsky wrote: > Hi! > > One of my script is getting data from mySQL database and then lists it all > on one page with loop, > What I need is to create a limit, let's say 10 items per page, then if we > got more then 10 items a link on the bottom will say: page2, page3, page4.. > etc basing on the amount of items existing there. > > In other words just like on Altavista and other search engines. > > I'm pretty much sure I can do it, but I don't have much time to play with > it. > > Could anyone give me an example of code or a script available somewhere else > that uses the same sorting? > Does anyone know where can I find a script or a class that does that, so it > would make my life easier? > > Thanks, gurus! > > Maxim Maletsky - maxim@j-door.com > <mailto:maxim@j-door.com> > Webmaster, J-Door.com / J@pan Inc. > LINC Media, Inc. > TEL: 03-3499-2175 x 1271 > FAX: 03-3499-3109 > > http://www.j-door.com > <http://www.j-door.com/> > http://www.japaninc.net > <http://www.japaninc.net/> > http://www.lincmedia.co.jp <��m1� > /�p���8��http://www.lincmedia.co.jp/> > > > px.sklar.com and look under databases for Mysql Next/Prev records, or something very close to that. It only works (to my knowledge) with Mysql but could probably work with any DB that has LIMIT. Oh and ignore the include in the first or second line. -- David Robley | WEBMASTER & Mail List Admin RESEARCH CENTRE FOR INJURY STUDIES | http://www.nisu.flinders.edu.au/ AusEinet | http://auseinet.flinders.edu.au/ Flinders University, ADELAIDE, SOUTH AUSTRALIA