Re: [PHP] Re: google style paginating

IMHO a PEAR pager package sounds like a sledgehammer when all that's needed is a hammer. Cheers, Rob. On Fri, 2003-08-22 at 17:59, Rob Yelvington wrote: > The Pear Pager class works like a champeen, too. It'll paginate results > however you'd like it to. > > ~Rob > > > Chris W. Parker wrote:

Re: [PHP] Re: google style paginating

The Pear Pager class works like a champeen, too. It'll paginate results however you'd like it to. ~Rob Chris W. Parker wrote: Robert Cummings on Thursday, August 21, 2003 4:46 PM said: Don't retrieve ALL the queries then only display a subset. Otherwise what's th

RE: [PHP] Re: google style paginating

Robert Cummings on Thursday, August 21, 2003 4:46 PM said: > Don't retrieve ALL the queries then > only display a subset. Otherwise what's the point of using the LIMIT > clause for conservation of resources? The "SELECT COUNT( * ) FROM > foo" query is usually optimi

Re: [PHP] Re: google style paginating

Ummm I wouldn't do what these guys suggest (at least not all of it)... perform two queries, one counting the total number of returns the other to actually get the subset. Don't retrieve ALL the queries then only display a subset. Otherwise what's the point of using the LIMIT clause for conservation

[PHP] Re: google style paginating

just split up your total number of results ($num_rows) by the results per page (10, i think) and create a for loop to loop from page1 to pagex, creating a link with offset for each one. simple. "Ted Conn" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi I am new to this newsgroup a