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
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
