Re: Re-Sorting query results

From: Justin Wyer (justin_at_isogo.co.za)
Date: 05/19/04 

Date: Wed, 19 May 2004 13:03:50 +0200

Steve wrote:

> On most websites that let you search the site, the results are
> returned in many rows of data. By clicking on the column
> heading you are able to re-sort the data based on that column.
>
> How's the best way to accomplish this via PHP? Would clicking
> the link of the column heading would you perform another query
> with an ORDER BY clause, or somehow sort the data that was
> returned from the original query. A code snippet would be
> great.
>
> TIA - Steve
Well since the database is faster than PHP i would say run another query
with a different ORDER BY, sorting large multidimensional arrays in PHP
will generate much more overhead.

Relevant Pages

  • RE: Filtering a subform using many combo boxes
    ... "Steve Sanford" wrote: ... SELECT AssignedPriority, AssignedPriorityDetail FROM tblAssignedPriority ... I followed you instructions to the letter and every one of the criteria ... open the query "qryProjects" in design view. ...
    (microsoft.public.access.forms)
  • Re: query for multiple results
    ... SELECT yourFields from yourTable WHERE ... Steve D ... "Tom Ellison" wrote: ... When i run the query, the parameter query dialog box opens. ...
    (microsoft.public.access.queries)
  • Re: Corstabquery or normal query
    ... H. Frank Situmorang ... "Duane Hookom" wrote: ... the Column Heading, and first of the name field as the value. ... This is my SQL for Query: ...
    (microsoft.public.access.reports)
  • Re: on input form showing error message for duplicate entry.
    ... Steve, If you know so much, why don't just help her?? ... check for duplicates. ... proceed with your insert query. ... form to have any sql statement on one line (my opinion). ...
    (alt.php)
  • Re: Recommend PHP-Based Dashboard?
    ... display them in charts inside gadgets. ... and this is to illicite a response from php developers in a php usenet group trying to foster some kind of fear in us all that you may change your mind and go java or windows or mac? ... /me passes a nice cool beer to Steve so he can relax a little. ... I worked on 'business intelligence' systems for some while at HP, and believe me, it is just old fashoined database design/query work as usual, but with a coat around it for managers so they can understand it too. ...
    (comp.lang.php)
Loading