Re: problems with different results on count() and select
| From: | Thomas Seifert | Date: | Thu, 16 Sep 2004 09:12:08 +0000 |
| Subject: | Re: problems with different results on count() and select | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-196838@lists.php.net to get a copy of this message | ||
On Thu, 16 Sep 2004 10:43:46 +0200, Merlin wrote:
> Theoreticly the result number of the first select statement should be identical
> with the count statement, but it is not.
>
> Has anybody an idea how to fix that?
>
It can't be the same number as you are using a where clause in the second
statement so you are missing some rows there.
also your code for ordering in the first part might just be wrong, but you
didn't show this code.
thomas