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

On 6 Mai, 01:37, "christian" <christ... (AT) comdif-nospam (DOT) com> wrote:
All you need is a bit of math

mysql> set @number=0.01;
Query OK, 0 rows affected (0.00 sec)

mysql> select ceiling(@number*20)/20;
+------------------------+
1 row in set (0.00 sec)

mysql> set @number=0.06;
Query OK, 0 rows affected (0.00 sec)

mysql> select ceiling(@number*20)/20;
+------------------------+
1 row in set (0.00 sec)

mysql>

mysql> set @number=0.11;
Query OK, 0 rows affected (0.00 sec)

mysql> select ceiling(@number*20)/20;
+------------------------+
1 row in set (0.00 sec)

mysql> set @number=0.15;
Query OK, 0 rows affected (0.00 sec)

mysql> select ceiling(@number*20)/20;
+------------------------+
1 row in set (0.00 sec)

mysql>

Thanks for you answer it work great !!

I have changed
$result = mysql_query("SELECT
cardnum,callednum,disposition,billseconds,ceiling( (truncate((billcost +
1000)/10000,2))*20)/20,callstart,datecall FROM cdrs WHERE
disposition='ANSWER' and cardnum='$poste' ORDER BY callstart DESC ");

I have (billcost + 1000) because 1000 is the connection price



"cvh@LE" <christian.hansel (AT) cpi-service (DOT) com> a écrit dans le message de news:
80583eaa-169c-49e2-a75f-a598ea84ead3...oglegroups.com...
On 6 Mai, 01:37, "christian" <christ... (AT) comdif-nospam (DOT) com> wrote:
All you need is a bit of math

mysql> set @number=0.01;
Query OK, 0 rows affected (0.00 sec)

mysql> select ceiling(@number*20)/20;
+------------------------+
1 row in set (0.00 sec)

mysql> set @number=0.06;
Query OK, 0 rows affected (0.00 sec)

mysql> select ceiling(@number*20)/20;
+------------------------+
1 row in set (0.00 sec)

mysql>

mysql> set @number=0.11;
Query OK, 0 rows affected (0.00 sec)

mysql> select ceiling(@number*20)/20;
+------------------------+
1 row in set (0.00 sec)

mysql> set @number=0.15;
Query OK, 0 rows affected (0.00 sec)

mysql> select ceiling(@number*20)/20;
+------------------------+
1 row in set (0.00 sec)

mysql>

On 6 May, 10:02, "christian" <christ... (AT) comdif-nospam (DOT) com> wrote:
You are welcome to your answer Christian, but please do not top post.