reusing a result set?

[dstoltz]

Hi All,

 

I'm coming from a Classic ASP world, so I'm trying to understand this...

 

After I excute a loop like this:

 

while($row = mysql_fetch_object($result)){

...

...

}

 

I can no longer echo results from that object, like: echo $row->lname;

 

 

I equate this to looping through a recordset in ASP. Once your past the last record, you are at EOF. If you want to "go back" to the starting record, you have to do:

 

RecordsetName.MoveFirst()

 

Is there a way to do this kind of thing with my result object in PHP? If so, how?

 

Sorry if this is a dumb question.

 

Thanks!

[PFMaBiSmAd]

http://us4.php.net/mysql_data_seek

[zackcez]

Do you mean echoing the rows outside of the while loop or what exactly do you mean?