Zero Values
| From: | Ethan Rosenberg | Date: | Wed, 02 Sep 2015 03:36:03 +0000 |
| Subject: | Zero Values | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-49063@lists.php.net to get a copy of this message | ||
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