RE: [PHP] resetting record pointer

thanx... I had thought this function seeks a particular value and not a specific record numbner... I'll give it a try as well read more thoroughally next time... thanx > -----Original Message----- > From: Kevin Beckford [mailto:kbeckford@bigorbit.com] > Sent: Friday, August 04, 2000 9:04 AM > To: Joe Sheble a.k.a. Wizaerd; GPHP > Subject: Re: [PHP] resetting record pointer > > > http://www.zend.com/manual/function.mysql-field-seek.php > > I think that this is what you are looking for - it sets the > result pointer to a > specified offset. > ----- Original Message ----- > From: Joe Sheble a.k.a. Wizaerd <wizaerd@wizaerd.com> > To: General PHP LIst <php-general@lists.php.net> > Sent: Friday, August 04, 2000 11:24 AM > Subject: FW: [PHP] resetting record pointer > > > > yeah, that does work in that instance, thanx... > > > > but I'm also assuming that there is no way to reset the current > record to > > the first record? For looping through the recordset twice? > I'm making a > > table that aligns to the left listing all the authors of > messages. These > > are quicklinks to the actual specific messages, so I loop > through the entire > > recordset putting the names in the table. Then after closing > that table out > > I want to reloop through the record set to output the actual messages. > > > > Currently I'm doing it with two queries, but that also seems in > efficient as > > h*ll.... > > > > > -----Original Message----- > > > From: Matthew Kendall [mailto:mdkendall@hotmail.com] > > > Sent: Friday, August 04, 2000 12:25 AM > > > To: php-general@lists.php.net > > > Subject: Re: [PHP] resetting record pointer > > > > > > > > > "Wizaerd" <wizaerd@wizaerd.com> wrote ... > > > > After issuing a mysql_fetch_array call, is it possible to reset > > > > back to the first row? I make the first call to pull out a > few feilds > > > > for writing out titles, but then I want to loop through the entire > > > > resultset starting from the very beginning. Currently I go ahead > > > > and display the values from the first retrieved recordset, then put > > > > the others in a while loop. The problem is the code from > > > > displaying the first record set is duplicated inside the loop, which > > > > seems inefficient. > > > > > > instead of: > > > > > > fetch row > > > title stuff > > > row stuff > > > while( fetch row ) { > > > row stuff > > > } > > > > > > why not use: > > > > > > fetch row > > > title stuff > > > do { > > > row stuff > > > } while( fetch row ) > > > > > > The code (both versions) assumes there is always at least one result. > > > > > > > > > > > > -- > > > 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 > > > > > > -- > > 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 > >