Re: [PHP-DB] how to reuse DB results

2004-05-20 Thread John W. Holmes
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

RE: [PHP-DB] how to reuse DB results

2004-05-20 Thread Hutchins, Richard
-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

Re: [PHP-DB] how to reuse DB results

2004-05-20 Thread Cal Evans
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

RE: [PHP-DB] how to reuse DB results

2004-05-20 Thread Aaron Wolski
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

RE: [PHP-DB] how to reuse DB results

2004-05-20 Thread Hutchins, Richard
. That's just one way though. There are probably others available with and without the use of a db abstraction class. HTH, Rich > -Original Message- > From: Aaron Wolski [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 20, 2004 4:14 PM > To: [EMAIL PROTECTED] > Subj

[PHP-DB] how to reuse DB results

2004-05-20 Thread Aaron Wolski
Hi All, Got this logic problem I don't know how to solve. 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? Right now, I am making two calls to the Db to get th