Re: [PHP] converting a number
On Thursday 18 November 2004 18:50, Octavian Rasnita wrote: > Not exactly. And this query gives me an error. Fix the quotes. -- 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-general -- /* Patageometry, n.: The study of those mathematical properties that are invariant under brain transplants. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] converting a number
Not exactly. And this query gives me an error.
Thank you.
Teddy
- Original Message -
From: "Warren Vail" <[EMAIL PROTECTED]>
To: "Octavian Rasnita" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, November 18, 2004 11:24 AM
Subject: RE: [PHP] converting a number
> >
> > I have a number like 1.0122E9 and I want to convert it into a
> > real number in
> > a common notation and not in that scientific one (with E).
> >
> > I have seen that very long numbers are always converted
> > automaticly to that
> > notation and I need to insert that number in a MySQL database and in
that
> > case MySQL won't calculate well.
> >
> > Please tell me how to do that in PHP or in MySQL..
> >
> Is this what you were thinking of?
>
> $query = "insert table(floatcol) values(".sprintf("%2.4f",$yourno).") ";
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] converting a number
>
> I have a number like 1.0122E9 and I want to convert it into a
> real number in
> a common notation and not in that scientific one (with E).
>
> I have seen that very long numbers are always converted
> automaticly to that
> notation and I need to insert that number in a MySQL database and in that
> case MySQL won't calculate well.
>
> Please tell me how to do that in PHP or in MySQL..
>
Is this what you were thinking of?
$query = "insert table(floatcol) values(".sprintf("%2.4f",$yourno).") ";
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
