> I'm trying to get the total matched rows when I'm using "LIMIT 0, 10", > but I only get the number 10, when the total should be around 100. So, > can I get total matched rows without doing a separate query using > count()?
You first have to get the whole result set without the limit OR make use of count(*) and parse the result of count. Since it only returns 10, it's correct the the total matched rows is 10. sql query.... Regards, Jeroen Geusebroek -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php