[FX.php List] Multiple requests with an additional constraint...

[Bob Patin]

Steve,

Thanks for the suggestions; both very good... your 2nd suggestion  
sounds like a good one.

So let's assume I did the date search first (it would probably reduce  
the found set more than the other search. Would I then have to loop  
thru the records to reduce them, or is there another mechanism in PHP  
that would search the array for me?

I know how to loop thru the found set, but that seems slower than  
perhaps some other type of query might be. My knowledge of PHP  
extends just far enough to get around in FX, but other than some  
fairly minor string manipulation and date parsing, I'm a lightweight  
with PHP... :)

So if you have a suggestion on another way to cull the found set  
other than a loop, I'd appreciate any insights...

Thanks again,

Bob


On Oct 30, 2006, at 10:47 PM, Steve Winter wrote:

> 1. You could write a script to perform the find for you setting global
> fields to the values you wish to search on from FX, then calling the
> script to do the actual find...
>
> 2. perform the find with FX that will produce the smallest set of  
> records,
> either the date find or the domain name find, then do the second  
> find in
> PHP... so if you did the date find from FX, then ran a loop through  
> the
> returned values, pulling out those records which meet the domain  
> criteria
> (or the reverse, do the FX find for the domain criteria, then the date
> filtering in PHP...
>
>
> Couple of ideas... YMMV...
> Cheers
> Steve

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20061030/dc37925f/attachment.html