Re: Array help.
| From: | Joshua Kehn | Date: | Fri, 30 Jul 2010 19:06:11 +0000 |
| Subject: | Re: Array help. | ||
| References: | 1 2 3 4 5 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-307261@lists.php.net to get a copy of this message | ||
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