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.

> -----Original Message-----
> From: Marco Bleeker [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, November 20, 2002 9:06 AM
> Subject: Listing a table /Limit
> And how would I find out which portion (row number) the row 
> would be in, 
> that I would like to see in a listing?
> <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>

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to