Re: Help: Google like page functions

Basically, in your SQL, just use "LIMIT" Select * from foo where something = 'something_else' limit 0, 10; Select * from foo where something = 'something_else' limit 10, 10; Select * from foo where something = 'something_else' limit 20, 10; Select * from foo where something = 'something_else' limit 30, 10; Select * from foo where something = 'something_else' limit 40, 10; etc... Jeremy Brand :: Sr. Software Engineer :: 408-245-9058 :: jeremy@nirvani.net http://www.JeremyBrand.com/Jeremy/Brand/Jeremy_Brand.html for more - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - "LINUX is obsolete" -- Andy Tanenbaum, January 29th, 1992 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - http://www.JEEP-FOR-SALE.com/ -- I need a buyer Get your own Free, Private email at http://www.smackdown.com/ On Tue, 23 Jan 2001, Shane McBride wrote: > Date: Tue, 23 Jan 2001 20:59:03 -0500 > From: Shane McBride <php@riversidedesigns.net> > To: php-general@lists.php.net > Subject: Re: [PHP] Help: Google like page functions > > I found a great little snippet by accident that does the "Previous 123 Next" > links. If anyone is interested, here's the link to it: > > > http://www.phpbuilder.net/snippet/detail.php?type=snippet&id=21 > > > ----- Original Message ----- > From: "Shane McBride" <php@riversidedesigns.net> > To: <php-general@lists.php.net> > Sent: Tuesday, January 23, 2001 6:35 PM > Subject: [PHP] Help: Google like page functions > > > I thought this had been addressed earlier, but I could not find the thread. > > If I have a MySQL DB that has 50 records in it and I want to display 5 per > page. How do I do this. Also, 50 was just a nice round number, the number > will change constantly. > > All the search engines are doing this type of thing. I just can't seem to > figure out what I should search for. > > - Shane > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >