Aaron Wolski wrote:
Is there any way I can make a call to the DB for some records.
Display some info from a column or two say at the top of the page and
then display the full result set in a while() loop?
Look for the seek() function of whatever database you're using, i.e.
mysql_data_seek() to re
-Original Message-
> From: Aaron Wolski [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 20, 2004 4:26 PM
> To: 'Hutchins, Richard'; [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] how to reuse DB results
>
>
> Hi Richard!
>
> Thanks.
>
> Ok.. let me
adodb has a moveFirst() function. You should be able to use it to
display x rows then $rs->moveFirst() and then use a while loop to
display all of them.
HTH,
=C=
:
: Cal Evans
: Evans Internet Construction Company
: 615-260-3385
: http://www.eicc.com
: Building web sites that build your business
hile($resultset)
{
//display full result set here
}
Is my logic right or completely off base?
Thanks!
A
> -Original Message-
> From: Hutchins, Richard [mailto:[EMAIL PROTECTED]
> Sent: May 20, 2004 4:19 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] how to reuse DB
Off the top of my head, you could do the db call once, assign the full
result set to an array, pull off the parts you want at the top of the page,
then use reset($arrayname) to put the pointer back to the beginning of the
array then use a loop to print out the whole thing at the bottom of the
page.
