> I said "without doing another query" :-) Sure you can do count(*)
> beforehand...
Oh, sure, sorry! Too late, I guess.
--
Herzlich
Werner Stuerenburg
_
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 ยท Fax
> > He wants to know the maximum, like on a search for mysql at
> > google it says "Results 1 - 10 of about 2,580,000." He wants
> > to know that 2,580,000 number without doing another query.
> > I don't think that's possible.
>
> Of course it is. That's what I do all the time. That's what I was
>
> He wants to know the maximum, like on a search for mysql at google it says
> "Results 1 - 10 of about 2,580,000." He wants to know that 2,580,000 number
> without doing another query. I don't think that's possible.
Of course it is. That's what I do all the time. That's what I was
talking about.
He wants to know the maximum, like on a search for mysql at google it says
"Results 1 - 10 of about 2,580,000." He wants to know that 2,580,000 number
without doing another query. I don't think that's possible.
> I'm not sure if I understand your problem. You should get exactly
> $end results if
I'm not sure if I understand your problem. You should get exactly
$end results if there are more in the result set. Only if you
reach the end of your loop, you will get less.
Example: You have 48 results and show them in batches of 10. Then
you should get 10, 10, 10, 10, 8 results if you show the
Hello,
I want to know if there is some way to return the number of rows in a query,
the complete query,
while using a LIMIT $start, $end command.
Unfortunately, so far, using
$result = mysql_query("$SELECT");
$qct = mysql_num_rows($result);
Results in $qct being equal to $end, which I alrea
Hello,
I want to know if there is some way to return the number of rows in a query,
the complete query,
while using a LIMIT $start, $end command.
Unfortunately, so far, using
$result = mysql_query("$SELECT");
$qct = mysql_num_rows($result);
Results in $qct being equal to $end, which I alrea
