way to copy a resource type ?

chucklarge

Hello,

Is there a way to copy a type resource ? such as a mysql_query?
I thought of serialize, but it does not support resource.

for example

$query = mysql_query("SELECT .....");

$querycopy = $query;

Thanks,
Chuck

bradgrafelman

chucklarge wrote:
Is there a way to copy a type resource ?

Sure. Look at your "example" for an example of how to do this.

MarkR

If you use assignment in this way, it won't actually copy the resource, simply both variables refer to the same one.

To copy a resource you must use a method specific to the resource type; many resource types are not copyable at all, probably including mysql results.

I'm not sure why you WANT to copy the resource, but if you know your result set is of reasonable size (e.g. will fit in RAM), you may want to read the entire result set into a variable and copy that instead.

Mark

NogDog

Don't know why you'd want to do it, but assuming you have a reason, you could brute force it:

$sql = "select.........";
$query = mysql_query($sql);
$queryCopy = mysql_query($sql);

PS: Telling us why you want to do it might lead to a discussion finding a better way to do it where copying a resource would not be necessary at all.