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