I am trying to retieve a number (1,000,000) from mysql db. The number is being formatted automatically as 1.0e+006 when I insert it into the db. When I try to retrieve this value all I get is the 1.0+e006. Is there a way to format it back to the orginal 1,000,000? Thanks.
if you have something like:
$myval = mysql_fetch_row($blah,$blah2);
then use the double construct to convert it to a more readable number:
$newval = (double)$myval[0];