Re: Listing a table

From: 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) >

« previous php.general (#125181) next »