On Tue, Sep 1, 2015 at 11:36 PM, Ethan Rosenberg <
erosenb...@hygeiabiomedical.com> wrote:
> Dear List -
>
> I have a payment/charges table -
>
> mysql> describe Charges;
> +--+--+--+-+-+---+
> | Field| Type | Null | Key | Default | Extra |
> +--+--+--+-+-+---+
> | Indx | mediumint(9) | NO | PRI | 0 | |
> | Cust_Num | smallint(5) unsigned | NO | | NULL| |
> | Balance | decimal(10,2)| YES | | NULL| |
> | Payments | decimal(10,2)| YES | | NULL| |
> | Charges | decimal(10,2)| YES | | NULL| |
> | Notes2 | text | YES | | NULL| |
> | Date | date | YES | | NULL| |
> | PH1 | char(4) | YES | | NULL| |
> | PH2 | char(4) | YES | | NULL| |
> | PH3 | char(5) | YES | | NULL| |
> +--+--+--+-+-+---+
> 10 rows in set (0.11 sec)
>
> If Balance, Payments and Charges all equal 0, and then
>
> select * from Charges,
>
> the rows w/ all zero values will not be displayed.
>
> Why?
>
> TIA
>
> Ethan
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
The default value field is NULL, which is not the same as zero. When
inserting the records add '0' as a value if you want. Another way to do it
is during the SELECT ad an ifnull use '0'.