Re: [PHP3] how to print long records in more than one pages??

In article <000a01bfda3b$6c7696a0$4588fbd8@peerwork.com>, cicy@peerwork.com ("Cicy Chen") wrote: > Hi All, > > I have a set of records retrieved from database which is in array. I want to > print them out in a nice format, each page only shows 4 items. in that way > it could be in more than one or 2 pages. I have a "next" hyperlink and > ...when user click on the "next", it would show the rest of records with a > same http address http://shoppingcart/rings.php3 I'm > wondering if you > know the effective way of dealing with it. any suggestion is appreciated. > thank you. Depends on the database, but basically you don't get all the records, only the ones you need on that page. MySQL/PostgreSQL -- See database docs for "LIMIT" clause Others -- See database docs for "CURSOR" object -- Richard Lynch | If this was worth $$$ to you, buy a CD US Customer Support Director | from one of the artists listed here: Zend Technologies USA | http://www.L-I-E.com/artists.htm http://www.zend.com | (this has nothing to do with Zend, duh!)