COUNT(*) fails in PHP3
| From: | Piotr Fetras | Date: | Wed, 07 Feb 2001 15:56:49 +0000 |
| Subject: | COUNT(*) fails in PHP3 | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-5437@lists.php.net to get a copy of this message | ||
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