ReOrder result set, Save a trip to DB/Srv

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
I've been using Pear::DB

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:

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 ?

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.

Site Timeline