[SOLVED] displaying number problem

[shadiadiph]

I have the following script to display a number

 

$value      = $row["value"];
$newvalue = number_format($value,2);

echo'<td class="tradeinfo"> '.$newvalue.' </td>'

 

problem is it displays fine as long as the number is less than 999,999 displays 27,300.00 999,999.00 etc but when the value is over 1,000,000 it always displays as 999,999.99 ?? the table is set as float 7,2

[shadiadiph]

mm i just changed float to just float instead of float7,2

 

now it displays the millions and i have changed

 

$newcalue = number_format($value,2,'.', ',');

 

now the problem is when i put 11567307 as the number it only displays 11,567,300.00  how do i stop it rounding the number down?

 

[shadiadiph]

dont worry i solved it already needed to set the number field in the database to decimal