[SOLVED] how to display the SUM using phppppppppppp .. weeeeee

[imarockstar]

I am grabbing all the data from a mysql row and adding them all together .. easy .. foo shooo ..

 

but when I get an even number like 200.00 or 394.50 its being displayed like this : 200 or 394.5

 

is there a way I can add the .00 or 0 (after a single digit cent) if the total needs one ?

 

here is my code :

 

// merch sales from tourdates
$query = ("SELECT SUM(merchsold) FROM showstats WHERE showdate < '$today' && showtype = 'td'  && userid = ". $_SESSION['id']);  
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)){

if ( $row['SUM(merchsold)'] != '' ) {  $tdmerchsold = $row['SUM(merchsold)']; }
else { $tdmerchsold = "0**"; }

}

 

[Mark Baker]

number_format()

[taquitosensei]

use sprintf

$num="3.5";
echo sprintf("%.2f", $num);