Re: Zero Values

On Tue, Sep 1, 2015 at 11:36 PM, Ethan Rosenberg < erosenberg@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'.