I'm trying to figure out if what I want to do is possible. Here's the task at hand. I want to make a query call to mysql and get a result handle back. No problem so far. However, I also want to be able to manipulate this data (using mysql_fetch_array or something like that) in TWO different ways; therefore, ideally, I'd like to keep a separate copy of the result handle (meaning not referenced/aliased to the original).
Is there a way to do this? Obviously, the easy way to do such a task is to simply make another query call to mysql to get a 2nd result handle, but that seems to be a waste of resources. I was also able to play with the "mysql_data_seek" pointer function, and that was able to help me do what I wanted to do (I was able to manipulate the array pointer, and then move it forward/back accordingly). However, the easiest solution for me would be to keep a separate copy that can be accessed as its own entity. I'm not sure if this is possible or not. Can someone confirm or deny my curiosity?
Thanks much.
