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. 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:aaronjw@xxxxxxxxxxxxx] > Sent: Thursday, May 20, 2004 4:14 PM > To: php-db@xxxxxxxxxxxxx > Subject: how to reuse DB results > > > 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 the data I need to > display at the top of the page and then a second query to retrieve the > full result set. > > I'm confused! > > Thanks for any help! > > Aaron > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
