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

[Someone]

try value list on that field

On Aug 20, 2008, at 10:28 AM, Bob Patin wrote:

> 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
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>