----- Original Message -----
From: "Marco Bleeker" <[EMAIL PROTECTED]>
Sent: Tuesday, November 19, 2002 8:34 PM
Subject: [PHP] Listing a table

> 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
> 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 ?

Use limit.  To get first 20 rows:
"Select * from mytable order by index_field limit 0,20"

Next 20 rows:
"Select * from mytable order by index_field limit 20,20"

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

Reply via email to