round up Sorry but I'm very newbie for writing my own script
I try
$result = mysql_query("SELECT
cardnum,callednum,disposition,billseconds,truncate (billcost /10000,2)
,callstart FROM cdrs WHERE disposition='ANSWER' and cardnum='$poste' ORDER
BY callstart DESC ");
or
$result = mysql_query("SELECT
cardnum,callednum,disposition,billseconds,round(bi llcost /10000,2)
,callstart FROM cdrs WHERE disposition='ANSWER' and cardnum='$poste' ORDER
BY callstart DESC ");
I whant up rounded billcost by step of 0,05
ex 0,01 is 0,05 or 0,06 is 0,1 and 0,11 is 0,15
Any idea ?
Thanks |