pregunta como puedo formatear los campos que se llaman pago ???
digo lo ideal seria redondearlos pero la funcion
"ROUND(valor,decimales)"
NO ME FURULA
sql
SELECT cuenta.folio, cuenta.no_credito, cuenta.nombre, cuenta.domicilio, cuenta.colonia, cuenta.poblacion, cuenta.ciudad, cuenta.cp, saldo.saldo AS suerte, IF( saldo.saldo > 999.99,FORMAT(saldo.saldo * 1.35,2),FORMAT(saldo.saldo+400,2)) AS deuda, curdate() AS HOY, IF( saldo.saldo > 999.99,(saldo.saldo * 1.35)*0.5,(saldo.saldo+400)*.05) AS pago1, (curdate() + INTERVAL 7 DAY) AS Fpago1, IF( saldo.saldo > 999.99,(saldo.saldo * 1.35)*0.055555,(saldo.saldo+400)*0.5) AS pago2, (curdate() + INTERVAL 37 DAY) AS Fpago2, IF( saldo.saldo > 999.99,(saldo.saldo * 1.35)*0.055555,(saldo.saldo+400)*0.5) AS pago3, (curdate() + INTERVAL 67 DAY) AS Fpago3, IF( saldo.saldo > 999.99,(saldo.saldo * 1.35)*0.055555,(saldo.saldo+400)*0.5) AS pago4, (curdate() + INTERVAL 97 DAY) AS Fpago4, IF( saldo.saldo > 999.99,(saldo.saldo * 1.35)*0.055555,(saldo.saldo+400)*0.5) AS pago5, (curdate() + INTERVAL 127 DAY) AS Fpago5, IF( saldo.saldo > 999.99,(saldo.saldo * 1.35)*0.055555,(saldo.saldo+400)*0.5) AS pago6, (curdate() + INTERVAL 157 DAY) AS Fpago6, IF( saldo.saldo > 999.99,(saldo.saldo * 1.35)*0.055555,(saldo.saldo+400)*0.5) AS pago7, (curdate() + INTERVAL 187 DAY) AS Fpago7, IF( saldo.saldo > 999.99,(saldo.saldo * 1.35)*0.055555,(saldo.saldo+400)*0.5) AS pago8, (curdate() + INTERVAL 217 DAY) AS Fpago8, IF( saldo.saldo > 999.99,(saldo.saldo * 1.35)*0.055555,(saldo.saldo+400)*0.5) AS pago9, (curdate() + INTERVAL 247 DAY) AS Fpago9, IF( saldo.saldo > 999.99,(saldo.saldo * 1.35)*0.055555,(saldo.saldo+400)*0.5) AS pago10, (curdate() + INTERVAL 2777 DAY) AS Fpago10 FROM saldo INNER JOIN cuenta ON cuenta.id_cuenta = saldo.id_cuenta WHERE cuenta.folio = '151051656' ORDER BY saldo.id_saldo DESC
o como podría ocupar el valor que se genero y que se llama deuda ??
lo podria ocupar o tengo que crear una tabla temporal ???
NOTA esto es para un reporte en RaveRepots