And the the value is 10...I would like to get the value 100! I have tried count(*) to no avail...Is there anything else I can try, other than to run the query a second time without the limit?
Hi does anyone know of a way that I can return the overall row count of query where a limit is being implemented..
ie:- Say I have a query with 100 rows of info...
PHP:
SELECT * FROM table1 LEFT JOIN table2
ON id=id
LIMIT 0,10
In the above query the I get 10 rows returned using limit and in PHP I can use this value by calling...
PHP:
mysql_num_rows($result);
And the the value is 10...I would like to get the value 100! I have tried count(*) to no avail...Is there anything else I can try, other than to run the query a second time without the limit?
Correct me if I'm wrong but 10 is the overall count for this query. The limit clause will only return the 10 rows specified, it doesn't return all 100 and then just display 10. So it will require a second query without Limit.....I think