RE: [PHP-DB] Round a number
| From: | Gary dot Every at ingramentertainment dot com | Date: | Fri, 03 Oct 2003 15:18:49 +0000 |
| Subject: | RE: [PHP-DB] Round a number | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-30822@lists.php.net to get a copy of this message | ||
Try the rtrim function in php
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forward"
mailto:gary.every@ingramentertainment.com
http://accessingram.com
> -----Original Message-----
> From: Shaun [mailto:shaun@mania.plus.com]
> Sent: Friday, October 03, 2003 10:12 AM
> To: php-db@lists.php.net
> Subject: [PHP-DB] Round a number
>
>
> Hi,
>
> I have a query that returns a number from culculation in my table. It
> returns say 4.00, 8.75, 0.00, 12.50 etc. How can I get MySQL
> to return the
> number without any zeros, i.e. 4, 8.75, 0, 12.5 etc?
>
> Thanks for your help
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>