Hi, all!

In mySQL, I can paginate a list of records quite easily. For example, if I have the query set to 20/page and want page 3, the SQL would read:

SELECT * FROM table_name ORDER BY field_name ASC LIMIT 20 OFFSET 40;

and the result set would consist of 20 records starting at the 40th and ending at the 59th.

How do I do the same thing in FM using PHP?

Thanks!

Steve
--
Rev. Steve Willis
Director of Software Development
Life Christian University
P.O. Box 272360
Tampa, Fl 33688
(520) 891-3721


CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.


--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/