I notice your query says
SELECT x,y,COUNT(y),z FROM ... GROUP BY y
It was my understanding that when using aggregate function, you need to
group by each field in your select-clause, so your query should be:
SELECT x,y,COUNT(y),z FROM ... GROUP BY x, y, z
Hope this helps,
Yves Sucaet
Iowa St
I've forwarded this msg to the php-db list ([email protected]). Try
to subscribe to it.
The mysql extension for php is only an interface between php and mysql -
the parsing of queries is done within mysql itself. So if your query
works through CLI it will also work from within php. Try to v
