Re: [PHP-DB] Re: "COUNT() returns 0 if there were no matching rows." .... really?!

2009-08-07 Thread John Butler
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

Re: [PHP-DB] Re: "COUNT() returns 0 if there were no matching rows." .... really?!

2009-08-06 Thread Govinda
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.) If a table doesn't have a record for a given date, I wouldn't expect t

Re: [PHP-DB] Re: count

2002-04-11 Thread Mike
Mike - Original Message - From: "Ron Allen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 11, 2002 7:13 AM Subject: [PHP-DB] Re: count > I know how to get the results for the total number of records > select count(*) from $table > but how do I put them into a variab