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

[Jonathan Schwartz]

That's it.  VALUE LIST.  Thanks guys. Sorry for the vague question.

J

At 10:32 AM -0400 8/20/08, Someone wrote:
>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
>>
>
>_______________________________________________
>FX.php_List mailing list
>FX.php_List at mail.iviking.org
>http://www.iviking.org/mailman/listinfo/fx.php_list


-- 
Jonathan Schwartz
Exit 445 Group
jonathan at exit445.com
http://www.exit445.com
415-370-5011