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

[Steve Winter]

Bob,

I'd be inclined just to use a foreach through the returned set, so you'd
end up with something like;

foreach($returnedData as $key -> $value) {
  if($value['domainName'][0] == 'domain 1' || 
     $value['domainName'][0] == 'domain 2' ||
     $value['domainName'][0] == 'domain 3') {
  // output whatever you want here }}

Cheers
Steve

> 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
> 
>