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
