[FX.php List] Sorting the found records

[Jerry Do]

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