Re: PHP count rows

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.
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.