Re: [PHP-DB] Zero Values

2015-09-02 Thread Karl DeSaulniers
On Sep 1, 2015, at 10:36 PM, Ethan Rosenberg wrote: > Dear List - > > I have a payment/charges table - > > mysql> describe Charges; > +--+--+--+-+-+---+ > | Field| Type | Null | Key | Default

Re: [PHP-DB] Zero Values

2015-09-02 Thread Karl DeSaulniers
On Sep 2, 2015, at 11:02 PM, Ethan Rosenberg wrote: > Dear list - > > I know that I am making a mistake somewhere. but am lost for an answer. > > mysql> select Payments from Charges where if(Payments, Payments, 0); > +--+ > | Payments | >

Re: [PHP-DB] Zero Values

2015-09-02 Thread Ethan Rosenberg
On 09/01/2015 11:43 PM, Aziz Saleh wrote: 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

Re: [PHP-DB] Zero Values

2015-09-01 Thread Aziz Saleh
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 |