ReOrder result set, Save a trip to DB/Srv

[awebguynow]

I've been using Pear::DB

http://pear.php.net/reference/DB-1.7.6/

I don't know what the best sorting options are; Sure you could
re-query the DB ('order by').

I suppose you could place the $RS in a multi-dim array (in Session) and
re-sort that.

If you could do it all on the client side, that would be impressive
too. Here's 1 model:

http://kryogenix.org/code/browser/sorttable/

pretty nifty, although I see there are assumptions for date formats
that aren't consistent with standard MySQL dates: yyyy-mm-dd

Before I reinvent the wheel, has anyone done resorting or is there an
easy way ?

[awebguynow]

Re: ReOrder result set, Save a trip to DB/Srv

I also envision a Filtering system, to further query and refine the
data (returning a subset), without re-executing a query against the DB.