On Fri, 3 Oct 2003, Shaun wrote:
> 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?
You can't in MySQL. At least not that I could figure out.
In PHP you could write code to do it.
$float = 4.00;
$text = (string)$float;
if (preg_match("/\d+\.0+$/", $text)) {
list($final) = (int)split("\.", $text);
} elseif {
... blah blah blah
}
code is untested, I may have written it wrong.
---------------------------------------------------------------------------
Peter Beckman Internet Guy
beckman@purplecow.com http://www.purplecow.com/
---------------------------------------------------------------------------
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
