[FX.php List] Query for Last Record Created of a Found Set

Dale Bengston dbengston at preservationstudio.com
Fri May 26 14:46:00 MDT 2006


Hi Kim,

You can grab the last record in a found set (returned by FX) by using  
end($returnedData['data']). Using end returns the last element in any  
array.

http://us3.php.net/manual/en/function.end.php

Hope this helps,
Dale


--
Dale Bengston | Streamline Studio, LLC | dbengston at streamline-studio.com
Associate Member, FileMaker Solutions Alliance





On May 26, 2006, at 3:16 PM, Kim Hawksworth wrote:

> I’m  developing an application that needs to pass the field values  
> from the last record created in a found set to a form.  Is there a  
> way with fx and php  to identify the last record created in a found  
> set?  The found count will vary from query to query.
>
> Sof far I’ve thought about creating a portal and using the Get 
> (PortalRowNumber) function, but then you have the issue of making  
> sure the records are sorted so the last record is always in the  
> first row.  Is there a better solution?
>
> Thanks for your help.
>
> --Kim
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list





More information about the FX.php_List mailing list