PHP DB - Mysql Function to display number of records

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Mysql Function to display number of records

Jovan Ross

2004-11-02, 8:55 pm

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.

Sponsored Links