[PHP-DB] Number of Lines in Table.

Dear List - This works: mysql> describe Purchases; +---+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-++ | indx | smallint(6) | NO | PRI | NULL| auto_i

Re: [PHP-DB] Number of Lines in Table.

See : http://stackoverflow.com/questions/14682448/how-to-get-the-total-row-count-with-mysqli Matt On Sep 2, 2014 7:38 PM, "Ethan Rosenberg" wrote: > Dear List - > > This works: > > mysql> describe Purchases; > +---+-+--+-+-++ > | Field | Type

Re: [PHP-DB] Number of Lines in Table.

On Sep 2, 2014, at 9:37 PM, Ethan Rosenberg wrote: > Dear List - > > This works: > > mysql> describe Purchases; > +---+-+--+-+-++ > | Field | Type| Null | Key | Default | Extra | > +---+-+--+-+-+--

Re: [PHP-DB] Number of Lines in Table.

Whoops, this should be.. print_r('Results { '.$rowarray.' }'); Karl DeSaulniers Design Drumm http://designdrumm.com On Sep 2, 2014, at 11:57 PM, Karl DeSaulniers wrote: > print_r('Results { '.$row.' }'); -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.

Re: [PHP-DB] Number of Lines in Table.

Karl, This works for small datasets, but when you have a large amount of data (either in terms of storage or row count) it is no longer practical. This is why people typically use the SQL row count instead of transferring all of the data to php and doing the work there. It is much more efficient.

Re: [PHP-DB] Number of Lines in Table.

I see. Ok thanks Matt. Will look into that if I start working with those size databases. My apology Ethan, wasn't aware of the scope. Best, Karl DeSaulniers Design Drumm http://designdrumm.com On Sep 3, 2014, at 12:09 AM, Matt Pelmear wrote: > Karl, > > This works for small datasets, but w

Re: [PHP-DB] Number of Lines in Table.

On Sep 3, 2014, at 12:13 AM, Karl DeSaulniers wrote: >> >> >>> Dear List - >>> >>> This works: >>> >>> mysql> describe Purchases; >>> +---+-+--+-+-++ >>> | Field | Type| Null | Key | Default | Extra | >>> +---+-+-