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

On Sep 3, 2014, at 12:13 AM, Karl DeSaulniers <[email protected]> wrote:
>> 
>> 
>>> Dear List -
>>> 
>>> This works:
>>> 
>>> mysql> describe Purchases;
>>> +-------+-------------+------+-----+---------+----------------+
>>> | Field | Type        | Null | Key | Default | Extra          |
>>> +-------+-------------+------+-----+---------+----------------+
>>> | indx  | smallint(6) | NO   | PRI | NULL    | auto_increment |
>>> | manf  | varchar(20) | YES  |     | NULL    |                |
>>> | itm   | varchar(50) | YES  |     | NULL    |                |
>>> | prc   | float       | YES  |     | NULL    |                |
>>> +-------+-------------+------+-----+---------+----------------+
>>> 4 rows in set (0.00 sec)
>>> 
>>> What is my error?
>>> 
>>> TIA
>>> 
>>> Ethan



Just for a little redemption.. :) 
I think this is what your looking for Ethan. 

http://stackoverflow.com/questions/5060366/mysql-fastest-way-to-count-number-of-rows

SELECT SQL_CALC_FOUND_ROWS [itm] FROM Purchases LIMIT 50 OFFSET 0;
SELECT FOUND_ROWS();


It says that FOUND_ROWS() has to be called immediately after the data selecting query.

HTH,
Best,

Karl DeSaulniers
Design Drumm
http://designdrumm.com