Re: COUNT(*) fails in PHP3
| From: | Tom Mathews | Date: | Thu, 08 Feb 2001 11:18:05 +0000 |
| Subject: | Re: COUNT(*) fails in PHP3 | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-5459@lists.php.net to get a copy of this message | ||
I run php4 on windows, linux and solaris with MySQL, MSSQL and Oracle 8i and the aggregate
functions seem to be fine. Same goes fro php3 on windows and linux with MySQL (except that the
aggregate functions are a bit limited here, so its not always worth bothering!).
Do you get an error message, either from php or you rdbms? Hard to tell what's wrong without a
bit more info.
Tom
Piotr Fetras wrote:
> hi all !
>
> I have problems while executing SQL with aggregation functions, even simple
>
> SELECT COUNT(*) FROM aTable
>
> stalls. It seems to be a problem in PHP3 itself since other odbc-based applications run well.
> There is simple but stupid solution for this problem: add "group by" phrase:
>
> SELECT COUNT(*) FROM aTable GROUP BY 1
>
> and it goes on.
> Is it the same in PHP4 ???
>
> piofet
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net
> For additional commands, e-mail: php-windows-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net