The problem with that is if you are requerying each time, you can get
screwed up if someone inserts into that range.

----- Original Message -----
From: "James Hart" <jamesh@w...>
To: "professional php" <pro_php@p...>
Sent: Tuesday, September 26, 2000 7:44 AM
Subject: [pro_php] Re: Using sql results returned from MySQL


> I'd be thinking about using SQL to do the hard work for me.
>
> Try applying a LIMIT clause to your SQL SELECT query. Something like:
>
> SELECT * FROM foo LIMIT 0,9
> SELECT * FROM foo LIMIT 10,19
>
> etc.
>
> That way, you can present a table with ten results at a time in, and make
> next and previous type buttons to navigate through your resultset.
>
> Hope that helps,
>
> James
>
> > -----Original Message-----
> > From: Adam Lang [mailto:aalang@s...]
> > Sent: 25 September 2000 22:35
> > To: professional php
> > Subject: [pro_php] Re: Using sql results returned from MySQL
> >
> >
> > You can fetch a range of rows.  You can tell it to fetch 1
> > through 10, then
> > 10 through 20, back to 1 through 10, etc.
> > ----- Original Message -----
> > From: "John Webb" <jwebb@r...>
> > To: "professional php" <pro_php@p...>
> > Sent: Monday, September 25, 2000 9:46 AM
> > Subject: [pro_php] Using sql results returned from MySQL
> >
> >
> > > I currently have a page that displays results of a
> > > simple SQL search using MySQL_fetch_row. My problem
> > >is that some results > can number into the hundreds of
> > >items and I was looking for a way to display them in smaller
> > >segments. I can figure out how to pause the display after
> > >displaying so many results, but what I am looking for is a
> > >way to skip back in the results if someone wanted to.
> > >Does mysql_fetch_row have a command to do this, or do
> > >I need to put the results into a temporary table with an
> > > autonumber field and work off that?
> > >
> > > Thank You,
> > > John