On Wednesday 20 November 2002 22:12, Matt Schroebel wrote:
> I was thinking you'd start at the beginning, displaying row 0 through
> row 19, and then have a next link, that will show rows 20 through 39,
> and so on.
Read the question again :) That's not what the OP wants.
> > And how would I find out which portion (row number) the row
> > would be in,
> > that I would like to see in a listing?
The only way I can think of to achieve this is to read all your rows into an
array and process it from there. I'm not sure whether it's possible in SQL --
but then again if you was looking for an SQL solution you would have posted
to the php-db list!
> > <Q>
> > Hello, how would I go about listing a portion of a MySQL
> > table, without an
> > overall selection criterium? I have a unique index field, but
> > it's a string
> > and not autoincremented (but manually and with gaps). I just
> > want to go to
> > one particular row (query on that index field) and then list,
> > say, 20 rows
> > before that point and 20 rows after it. So I can create an
> > output of 41
> > rows in a HTML table. Is there something like the dBase SKIP and GOTO
> > command? Should I do a query for each individual row (and get
> > 41 result
> > sets) or can I somehow walk through 1 result set ?
> > </Q>
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
Laundry is the fifth dimension!! ... um ... um ... th' washing machine
is a black hole and the pink socks are bus drivers who just fell in!!
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php