Accessing a query result more than once on same page?

cju

I have a query where I get a list of offices, and I use it to build a select box. The first time I access the query results to build a list of offices, no problem. It looks like this...

while ( $my_office = mysql_fetch_array( $office_result )) {

Now I have to build a list of offices again on the same page. If I try to build the list again using the same code...

	while ( $my_office =  mysql_fetch_array( $office_result )) {

I don't get anything... I tried changing the variable name $my_office to something else, still nothing it output in my while loop. It's like the $office_result is spent after the first time I used it.

What's up with that? 🙂 Thanks in advance...

reidme

Each time the script runs through the while loop the value of $my_office changes and the old value is lost. If you want to keep all the values available use a while loop to load all the values into an array so you can reference all the retrieved values at will. Other than that, is there any reason while you cannot run the same query again when you need the same values again?

matt_4013

It is spent after the first time it loops through 😉 The Internal array pointer is pointing to the last element of the array. Use the reset($array); function before the second loop and it will work 🙂

cju

That had crossed my mind, but I didn't know how to reset it. Of course, it's just "reset" ... 🙂

Thanks!

cju

As a follow-up to my question, I was having difficulty figuring out where and how to use reset(). I stumbled on this gadget which seems to work well also...

mysql_data_seek($office_result, 0);
while ( $my_office = mysql_fetch_array( $office_result )) {
//Do something
}

I spin the result array back to 0 before entering my loop. Same concept, this just happened to be easier for me. I'm sure I could have done the same thing with reset() had I been able to figure out where to put it.