[FX.php List] Getting a set of unique records

Bob Patin bob at patin.com
Wed Aug 20 08:28:29 MDT 2008


Jonathan,

Your question wasn't very clear, but if you mean that each record  
needs to be unique based on one of the fields, you could loop through  
the found set in PHP once you've retrieved it, and only display unique  
records. You'd want to sort your query results by that field, and then  
loop through, comparing the first record with the subsequent one each  
time through the loop.

Hope this helps,

Bob Patin
Longterm Solutions
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com
iChat: bobpatin
AIM: longterm1954
FileMaker 9 Certified Developer
Member of FileMaker Business Alliance and FileMaker TechNet
--------------------------
FileMaker hosting and consulting for all versions of FileMaker
PHP • Full email services • Free DNS hosting • Colocation • Consulting

On Aug 20, 2008, at 9:22 AM, Jonathan Schwartz wrote:

> Hi Folks,
>
> Drawing a blank on this one.
>
> I'm querying a many-to-many match table and need to end up just a  
> list of unique records based on one of the fields.
>
> How to do?
>
> J
> -- 
> Jonathan Schwartz
> Exit 445 Group
> jonathan at exit445.com
> http://www.exit445.com
> 415-370-5011
> _______________________________________________
> 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