Re: Count(*) with zero rows

2001-09-18 Thread Paul DuBois
At 7:40 PM -0400 9/18/01, Raymond Prisament wrote: >In the course of using MySQL the following issue has come up a few times; I >am unaware of the solution for it, but I am sure one exists, since it seems >fairly elementary. It has to do with the COUNT(*) and GROUP BY functions. > >Let's say I ha

RE: Count(*) with zero rows

2001-09-18 Thread Scott Mebberson
Hi Raymond, I have been having the same problem using the GROUP BY statement, even without the COUNT(*) function. I'm working with PHP and the way I got around this is to use arrays. I retrieved all rows from the table and then sorted them into seperate arrays according to, in your case, ClientN