Re: reusing MySQL results -- resetting mySQL pointer with mysql_data_seek()

Nope. Mysql_data_seek($result,0) and it is. ----- Original Message ----- From: "Daevid Vincent" <DayWalker@TheMatrix.com> To: "Mark Roedel" <MarkRoedel@letu.edu>; "George Wright" <GWright@mhiweb.com>; <php-general@lists.php.net> Sent: Wednesday, April 04, 2001 3:18 PM Subject: RE: [PHP] reusing MySQL results -- resetting mySQL pointer with mysql_data_seek() > Just my two cents here... > > I could be mistaken, but wouldn't this method hit the database twice? > > I would suggest you take your results the first time and store them in an > array or multidimensional array, then you can get to any element at any time > further down the page. > > > -----Original Message----- > > From: Mark Roedel [mailto:MarkRoedel@letu.edu] > > Sent: Wednesday, April 04, 2001 7:52 AM > > To: George Wright; php-general@lists.php.net > > Subject: RE: [PHP] reusing MySQL results > > > > > > > -----Original Message----- > > > From: George Wright [mailto:GWright@mhiweb.com] > > > Sent: Wednesday, April 04, 2001 9:35 AM > > > To: 'php-general@lists.php.net' > > > Subject: [PHP] reusing MySQL results > > > > > > > > > Hi All, > > > > > > I have a page with two forms. Both forms have drop-down option > > > lists that are populated by a the same query. The query and > > > db connection are all done before either form is introduced > > > (this is the select statement, mysql_pconnect(), mysql_select_db(), > > > and mysql_query()). > > > > > > I am using a while loop to build the options. The loop "engine" > > > is mysql_fetch_object(), which writes out the values inside of > > > option tags. > > > > > > Everything works fine the first time around, but when I call > > > the query result for the second time, it's as if there are no > > > rows to return so nothing is written out. No errors are being > > > thrown. > > > > Mysql_data_seek() is your friend. > > > > PHP has an internal pointer that it maintains as you move through your > > result set. At the end of your mysql_fetch_object while loop, that > > pointer is located at the end of the result set. > > > > Mysql_data_seek() is the means for you to "rewind" that pointer to the > > any specified row, including the first, of the result set. > > > > See > > > > http://php.net/manual/en/function.mysql-data-seek.php > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >