Re: converting a number
| From: | Octavian Rasnita | Date: | Thu, 18 Nov 2004 10:50:30 +0000 |
| Subject: | Re: converting a number | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-202399@lists.php.net to get a copy of this message | ||
Not exactly. And this query gives me an error.
Thank you.
Teddy
----- Original Message -----
From: "Warren Vail" <warren@vailtech.net>
To: "Octavian Rasnita" <orasnita@fcc.ro>; <php-general@lists.php.net>
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).")
> ";
>