Re: [PHP-DB] Rounding

2004-04-07 Thread Ng Hwee Hwee
PROTECTED]> Sent: Thursday, April 08, 2004 10:06 AM Subject: 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..

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 >

Re: [PHP-DB] Rounding

2004-04-07 Thread Larry E . Ullman
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 that by 10. Larry -- PHP Database Mailing