Copy A MySQL Result Object

[JustinK101]

I require two copies of a mysql result object. I am simply doing:

 

$result = mysql_query($sql) or die(mysql_error());
$temp_result = $result;

 

But when I call:

 

while($row_temp = mysql_fetch_object($temp_result))

 

It seems to unset the $result object as well.

[JustinK101]

I just read a little more, I need to make a copy of a resource, which in my case is $result.