Re: [PHP-DB] Rounding
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 need one decimal place still.. multiply by 10 ceil() divide by 10 -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- /* In Oz, never say krizzle kroo to a Woozy. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Rounding
whoa! thanks so much! you guys are smart! hahaha.. i just love this list and all the helpful souls out there! :o) - Original Message - From: Larry E. Ullman [EMAIL PROTECTED] To: Ng Hwee Hwee [EMAIL PROTECTED] Cc: DBList [EMAIL 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.. 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 List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php