Re: [PHP-WIN] COUNT(*) fails in PHP3

2001-02-08 Thread Tom Mathews
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,

Re: [PHP-WIN] COUNT(*) fails in PHP3

2001-02-07 Thread Toby Miller
ot;<"php-windows"" <[EMAIL PROTECTED]> Sent: Wednesday, February 07, 2001 10:56 AM Subject: [PHP-WIN] COUNT(*) fails in PHP3 > hi all ! > > I have problems while executing SQL with aggregation functions, even simple > > SELECT COUNT(*) FROM aTable > >

[PHP-WIN] COUNT(*) fails in PHP3

2001-02-07 Thread Piotr Fetras
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