How do I re-use query results?

[eluser]TheFuzzy0ne[/eluser]
What's wrong with copying the result array/object to a variable, and re-using that?

You are using the result array anonymously. Really, result_array/result are both single-use methods. If you want to re-use the result array, you'll need to store it somewhere.

Hopefully this makes sense?