Re: PHP count rows

[Michael Ryan <michaelrtr@xxxxxxxxx>]

Thanks Mike and Sean...I think I was overthinking...appreciate the help!

On Tue, May 18, 2010 at 5:14 PM, Porterfield, Sean <
SPorterfield@xxxxxxxxxxxxxxxxxxxxxxx> wrote:

> > 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.