wilded
6/29/2017 - 7:36 AM

MYSQL if Statement

MYSQL if Statement

MYSQL if Statement
content_copyfile_download
IF(proType = '1', 'Productos', 'Servicios') as proType
(SELECT SUM(payAmount) FROM tblPayments WHERE payPurID = purID) TotalPayments, (SELECT IF(TotalPayments > 0, purTotalAmount-TotalPayments, purTotalAmount) AS TotalPayments2) as purAmountDue,