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()?
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);
Thanks,
Sumarlidi E. Dadason
_________________________________
E-mail: [EMAIL PROTECTED]
website: www.sed.is
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
