[FX.php List] Sorting the found records

Gjermund Gusland Thorsen ggt667 at gmail.com
Mon Nov 6 15:35:58 MST 2006


Did you try: array_multisort()

ggt667

2006/11/6, Jerry Do <hd78 at hotmail.com>:
> Is there a method to use to sort the found set on a table after executed the
> FMfind()?  Something like in Excel, a user click on the column to sort the
> data.
>
> Thanks,
> JD
>
> >From: Bob Patin <bob at patin.com>
> >Reply-To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> >To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> >Subject: Re: [FX.php List] Sorting the found records
> >Date: Mon, 6 Nov 2006 15:25:32 -0600
> >MIME-Version: 1.0 (Apple Message framework v752.2)
> >Received: from www.iviking.org ([66.93.225.134]) by
> >bay0-mc9-f2.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2444); Mon, 6
> >Nov 2006 13:25:47 -0800
> >Received: from ns1.iviking.org (localhost [127.0.0.1])by www.iviking.org
> >(Postfix) with ESMTPid 1BD7C390792; Mon,  6 Nov 2006 14:25:50 -0700 (MST)
> >Received: from patin.com (mail.longtermsolutions.com [216.84.23.219])by
> >www.iviking.org (Postfix) with ESMTP id B0B33390783for
> ><fx.php_list at mail.iviking.org>;Mon,  6 Nov 2006 14:25:47 -0700 (MST)
> >Received: from [216.84.23.196] (216.84.23.196) by patin.com with
> >ESMTP(Eudora Internet Mail Server X 3.2.8)
> >for<fx.php_list at mail.iviking.org>; Mon, 6 Nov 2006 15:25:33 -0600
> >X-Message-Info: LsUYwwHHNt29Bs7OKDPu65ve4vbIX08AlqEmu+C9v7E=
> >X-Original-To: fx.php_list at mail.iviking.org
> >Delivered-To: fx.php_list at mail.iviking.org
> >References: <BAY111-F3634DD495E2A1606C520C1CCF30 at phx.gbl>
> >X-Mailer: Apple Mail (2.752.2)
> >X-BeenThere: fx.php_list at mail.iviking.org
> >X-Mailman-Version: 2.1.4
> >Precedence: list
> >List-Id: "FX.php Discussion List" <fx.php_list.mail.iviking.org>
> >List-Unsubscribe:
> ><http://www.iviking.org/mailman/listinfo/fx.php_list>,<mailto:fx.php_list-request at mail.iviking.org?subject=unsubscribe>
> >List-Archive: <http://www.iviking.org/pipermail/fx.php_list>
> >List-Post: <mailto:fx.php_list at mail.iviking.org>
> >List-Help: <mailto:fx.php_list-request at mail.iviking.org?subject=help>
> >List-Subscribe:
> ><http://www.iviking.org/mailman/listinfo/fx.php_list>,<mailto:fx.php_list-request at mail.iviking.org?subject=subscribe>
> >Errors-To: fx.php_list-bounces at mail.iviking.org
> >Return-Path: fx.php_list-bounces at mail.iviking.org
> >X-OriginalArrivalTime: 06 Nov 2006 21:25:49.0456 (UTC)
> >FILETIME=[2136C100:01C701EA]
> >
> >Add this line to your FIND query for each sort that you want to do:
> >
> >$query->AddSortParam('sort_field_name','ascend');
> >
> >"Ascend" would of course be "Descend" for a descending sort...
> >
> >
> >On Nov 6, 2006, at 3:21 PM, Jerry Do wrote:
> >
> >>Hello,
> >>
> >>I have simple database that contain name_first, name_last,dob,...ect..
> >>I was able to find it through FX.php and display it on a table.
> >>I would like to sort the found set based on first name, lastname,  or dob
> >>depend on the user  without going back to do another find  from Filemaker.
> >>  I am thinking that I will have to use an array or  something like that,
> >>but I haven't grasp the logic yet.
> >>Any suggestion is welcome.
> >>
> >>Thank you,
> >>JD
> >>
> >>_________________________________________________________________
> >>Get FREE company branded e-mail accounts and business Web site from
> >>Microsoft Office Live http://clk.atdmt.com/MRT/go/
> >>mcrssaub0050001411mrt/direct/01/
> >>
> >>_______________________________________________
> >>FX.php_List mailing list
> >>FX.php_List at mail.iviking.org
> >>http://www.iviking.org/mailman/listinfo/fx.php_list
> >
> >_______________________________________________
> >FX.php_List mailing list
> >FX.php_List at mail.iviking.org
> >http://www.iviking.org/mailman/listinfo/fx.php_list
>
> _________________________________________________________________
> Add a Yahoo! contact to Windows Live Messenger for a chance to win a free
> trip!
> http://www.imagine-windowslive.com/minisites/yahoo/default.aspx?locale=en-us&hmtagline
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>


More information about the FX.php_List mailing list