Re: [PHP-DB] Rounding

2004-04-07 Thread Jason Wong
On Thursday 08 April 2004 09:56, Ng Hwee Hwee wrote: is there a way to do rounding up to the nearest tenth? can't use ROUND() cos i need something like this: 6.11 -- 6.2 6.15 -- 6.2 6.19 -- 6.2 6.20 -- 6.2 i know there is a ceil() function but that rounds up to the nearest integer.. i

Re: [PHP-DB] Rounding

2004-04-07 Thread Ng Hwee Hwee
: Re: [PHP-DB] Rounding 6.11 -- 6.2 6.15 -- 6.2 6.19 -- 6.2 6.20 -- 6.2 i know there is a ceil() function but that rounds up to the nearest integer.. i need one decimal place still.. If my math is right, you could multiply the number by ten, take the CEILING(), then divide