RE: Show query page by page

2001-11-14 Thread Rick Emery
Upon reading the other replies, I noted that they all pointed to the LIMIT constraint in the SELECT statement. Fair enough...but not far enough. Upon making your selection for page X, you must then pass a variable (perhaps using the URL parameter) to indicate where you are, so that you might kno

Re: Show query page by page

2001-11-13 Thread Robert Alexander
>Hi, > >I have a query result with 50 register and i want to show them in 5 pages, >every page show 10 register. > >Thanks , for your answers >Rhony http://www.mysql.com/doc/S/E/SELECT.html See 'LIMIT' /Rob -- Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting

Re: Show query page by page

2001-11-13 Thread Jeremy Zawodny
On Tue, Nov 13, 2001 at 04:24:47AM -0500, Auri Net SAC wrote: > Hi, > > I have a query result with 50 register and i want to show them in 5 > pages, every page show 10 register. Then you want to use the LIMIT option on your SELECT queries as shown in the manual. Jeremy -- Jeremy D. Zawodny, <[

Re: Show query page by page

2001-11-13 Thread Bill Adams
Auri Net SAC wrote: > Hi, > > I have a query result with 50 register and i want to show them in 5 pages, > every page show 10 register. LIMIT (see the manual) will help you. b. mysql - Before posting, please check: http:/