Re: sorting query results

Piotr......

> I recognized two
> ways of doing that:   (sorting results)
>
> 1. Issue a new query to the database each time the specific sorting was
> requested. In other words, let the database do the sorting and fetch the
> results.
>
> 2. Save the table into php array and and use php built-in functions to sort
> and refresh the table.
>
> Which of those methods would be most desired in terms of performance and
> according to "the best practices"?
> What would be possible drawbacks/advantages of those methods.

I'd do it in within the database query, it's just a little bit of
programming, probably just add 'ORDER BY' to your statement.  Possibly
more, but if you have a real complicated query you'll be spending a
bunch of time getting it right anyway.

If it's slow, then you start to optimize the query.

At any rate, that's the way I do it.....

brew
--

Strange Brew (brew@theMode.com)

Check out my Stock Option website http://www.callpix.com
and my Musicians Free Classified http://www.TheMode.com