Re: PHP count rows

["Porterfield, Sean" <SPorterfield@xxxxxxxxxxxxxxxxxxxxxxx>]

> From: Michael Ryan

> Seems simple...I want a count of the number of rows in a table, put that count into a variable, and then display that variable. Anyone have a snippet? Thanks...


I saw a suggestion of SQL  select count(*) from file; as one option for you.

If you're looking for the count of all records, no restrictions, you can probably also use RTVMBRD with NBRCURRCD
http://files.zend.com/help/Zend-Core-i5/i5_php_connector_api.htm#CL_Calls

Or possibly i5_info
http://www.easycom-aura.com/Data/WebHelp/PHP/api_functions/columns___parameters_information/i5_info.htm

I don't think I've specifically tested either one, since any count I wanted was based on a WHERE clause in a query rather than the complete file.

--
Sean Porterfield

This email is confidential, intended only for the named recipient(s) above and may contain information that is privileged.  If you have received this message in error or are not the named recipient(s), please notify the sender immediately and delete this email message from your computer as any and all unauthorized distribution or use of this message is strictly prohibited.  Thank you.