Re[2]: LIMIT with mysql_num_rows

2001-07-11 Thread Werner Stuerenburg
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. I

RE: Re[2]: LIMIT with mysql_num_rows

2001-07-11 Thread Chris Bolt
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

Re[4]: LIMIT with mysql_num_rows

2001-07-11 Thread Werner Stuerenburg
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

LIMIT with mysql_num_rows

2001-07-10 Thread Keith Spiller
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

LIMIT with mysql_num_rows

2001-07-10 Thread Keith Spiller
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