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

Here is an example of my current query:

$result = mysql_query("SELECT * FROM products WHERE price<'10' ORDER BY
price LIMIT 0, 10");
$num_rows = mysql_num_rows($result);

Sumarlidi E. Dadason

website: www.sed.is

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to