Re: Number of Lines in Table.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Sep 3, 2014, at 12:13 AM, Karl DeSaulniers <karl@xxxxxxxxxxxxxxx> 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
-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php






[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux