fx.php how to say: displaying records 1 through 20 on this page

[LML]

I'm using FX.php and Filemaker 7.

I know that if I want to say:

"The total number of records that match this search is XXXX"
using foundCount will provide me with the number XXXX.

However, I can't figure out how to get fx.php to return the number of records displayed on a certain page along with foundCount.

FOR EXAMPLE THIS INFO IS WHAT I WANT:

Shown below are records number 1 through 20 of 236 records.
(236 being my fictional foundCount number)
and successive pages like this ...
Shown below are records number 21 through 40 of 236 records.

How do I get the record numbers being displayed on a given page (like 1 through 20 etc) ? I can show you the code from my pages if that will help. Everything else on my pages works just great. It serves up 20 products per page. It finds all my products exactly as I want it to - but I just want to say "displaying records x through xx ... "

Thank you!
-Lynn, the FX.php newbie

[bastien]

I don't have a friggin clue what FX is, but what I do for these situations is run two queries. One uses the a COUNT with the WHERE clause to get the total number of mathcing records and the other uses the WHERE clause with the LIMIT clause to get the 20 records desired.

You can do it with one query and use MYSQL_NUM_ROWS and use a loop to only report the relevant dataset, but if the result set is really big this can have a distatorous effect on the server/site.