> 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("SEL
> 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
ROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, November 05, 2002 4:54 PM
Subject: PHP + MySQL, how to get total rows matched when using LIMIT 0, 10?
> I'm trying to get the total matched rows when I'm using "LIMIT 0, 10",
> but I only get
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 pro