Re: Re: "COUNT() returns 0 if there were no matching rows." .... really?!

From: Date: Fri, 07 Aug 2009 20:57:39 +0000
Subject: Re: Re: "COUNT() returns 0 if there were no matching rows." .... really?!
References: 1 2 3 4 5 6 7 8 9 10 11 12 13  Groups: php.db 
Request: Send a blank email to php-db+get-46429@lists.php.net to get a copy of this message
Here's an example (snip) from a var_dump of that $BuildPerUniqueDateArray: (note that the 'aweber_7solar_aw' table does NOT have a record for the date '2009-07-28', so I would expect to see that "1" to be a "0" there.)
I fixed this. The problem was the way I was building the array inside the while {} after the query, and also my lack of resetting the counter vars to 0 on each iteration of the date array. (not that anyone was bothering with this thread any more.. but just in case...) ------------ John Butler (Govinda) govinda.webdnatalk@gmail.com

« previous php.db (#46429) next »