[FX.php List] Record Count after the fact- Revisted

Gjermund Gusland Thorsen ggt667 at gmail.com
Wed Feb 21 04:34:12 MST 2007


I would put the new filtered result in $_SESSION['filteredResults']

ggt667

On 2/20/07, Joel Shapiro <jsfmp at earthlink.net> wrote:
>
> Hiya Jonathan
>
> I had a thought from your last thread that I don't remember seeing --
> though maybe I just missed it...
>
> As the php goes through your FM results, can you put all your newly
> filtered, looped-through data into a new array and then subsequently
> only use that?  So that your $filteredResults array would contain
> only the 300 'records' (of the 500 found by FM)?  Then it seems you
> could do whatever you wanted to that data: display the count, re-
> sort, prev/next, etc.
>
> maybe?
>
> -Joel
>
>
> On Feb 20, 2007, at 2:01 PM, Jonathan Schwartz wrote:
>
> > I'm baaa-aaack...with a wrinkle in the previously discussed issue
> > of post-processing a query result to accomplish a combines AND/OR
> > search.
> >
> > The problem now is dealing with PREV/NEXT links. I didn't realize I
> > had a problem until this point.
> >
> > The process:
> > 1) Perform part 1 of the search with FMP. Say it returns 500
> > records. $searchResult[foundCount'] reports 500, but this is before
> > the secondary search and can not be reported back to the user.
> >
> > 2) FMP passes 500 records back to PHP and Part 2 of the search (for
> > loop) reduces the 500 records to say, 300. I can report this back
> > to the user, but only if I set groupsize high (500) in order to be
> > sure to count all the records resulting from the second step.  Set
> > it lower and the count could be wrong.
> >
> > 3) I'm ready to post the first 20 records, but I have 300.  If I
> > set groupsize to 20, I get say 15.  Can't do that. If I decide to
> > accept the 300 records and stop the for loop at 20 records, that
> > would be wasting alot of cycles just to to toss 90% of the data.
> > Plus, how do I now deal with the second 20 records with PREV and
> > NEXT links?
> >
> > Am I thinking about this correctly?  I've already asked the end
> > user if they *really* need checkboxes versus radio buttons on this
> > search. ;-)
> >
> > J
> >
> >
> > --
> >
> > Jonathan Schwartz
> > FileMaker 8 Certified  Developer
> > Associate Member, FileMaker Solutions Alliance
> > Schwartz & Company
> > jonathan at eschwartz.com
> > http://www.eschwartz.com
> > http://www.exit445.com
> > 415-381-1852
> >
> > _______________________________________________
> > 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20070221/a33d3a30/attachment-0001.html


More information about the FX.php_List mailing list