Mysql Function to display number of records

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

 



I have a query that uses a LIMIT clause. Let's say it looks like this:

SELECT * FROM blah WHERE something<>0 LIMIT 5;

Ok, now my table really has 20 rows that satisfy the WHERE statement but I only retrieved 5. There was a function/statement that I could use to find out the total number of rows that would have been returned had I not used the LIMIT clause. Does anyone know what the statement was? I forget.

Yes, I'm using PHP btw.

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