Re: Listing a table
| From: | UberGoober | Date: | Wed, 20 Nov 2002 02:23:21 +0000 |
| Subject: | Re: Listing a table | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-125181@lists.php.net to get a copy of this message | ||
CHeck out ADODB, it makes this a pretty easy task.
http://php.weblogs.com/adodb
"Marco Bleeker" <marco_bleeker@hetnet.nl> wrote in message
news:4.3.2.7.2.20021120021435.00d0c5d0@pop.hetnet.nl...
> 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 ?
>
> Thanks, Marco
> --
> Marco Bleeker, Amsterdam, NL.
> Please do not distribute my email address to a third party
> Refer to www.ecocam.com for an email form (and more)
>