I have a result set that I use for two different puposes in a page. In the mySQL statement, I order it by field1. Later I need to reorder it by field2. Can I do this without moving all my results in to a redundant array?
Thanks, lambrite
You have to make a new SQL query returning the re-ordered rows or make an array of the first returned values and resort the array. I'd just make the new query; it's very fast that way.
