Re: [PHP] Array help.

[email protected] (Joshua Kehn) Fri, 30 Jul 2010 15:06:11 -0400

Newsgroups	php.general
Message-ID	<[email protected]>

On Jul 30, 2010, at 3:03 PM, Paul Halliday wrote:

>> 
>> Paul-
>> 
>> Why are those values not defaulted to 0 in the database?
>> 
>> Regards,
>> 
>> -Josh
>> 
>> 
> 
> They are defaulted, the query is grouping:
> 
> select count(status) as count, status from table group by status order
> by status desc;

Paul-

Correct, so stuff with a status of 0 will still show up unless I'm missing something.

Regards,

-Josh