On Sep 3, 2014, at 12:13 AM, Karl DeSaulniers wrote:
>>
>>
>>> Dear List -
>>>
>>> This works:
>>>
>>> mysql> describe Purchases;
>>> +---+-+--+-+-++
>>> | Field | Type| Null | Key | Default | Extra |
>>> +---+-+-
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
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.
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.
On Sep 2, 2014, at 9:37 PM, Ethan Rosenberg
wrote:
> Dear List -
>
> This works:
>
> mysql> describe Purchases;
> +---+-+--+-+-++
> | Field | Type| Null | Key | Default | Extra |
> +---+-+--+-+-+--
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
Dear List -
This works:
mysql> describe Purchases;
+---+-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-++
| indx | smallint(6) | NO | PRI | NULL| auto_i
