Zero Values
[email protected] (Ethan Rosenberg) Tue, 01 Sep 2015 23:36:03 -0400
| Newsgroups | php.db |
|---|---|
| Message-ID | <[email protected]> |
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