try
printf("Total : %.2f", round($hoursrow[0], 2);
Elliott
--
>From: "bryan" <[EMAIL PROTECTED]>
>To: "db" <[EMAIL PROTECTED]>
>Subject: [PHP-DB] subtotal
>Date: Wed, Feb 14, 2001, 10:55 AM
>
> Good day all...
>
> Does anyone know how, if I have a "*.00" at the, I can just leave that o
There is a ROUND function in MySQL...try this:
$totalsql = "SELECT ROUND(SUM(total),2) FROM entry WHERE
user_id='$passedid'";
$totalresult = mysql_query($totalsql);
$totalrow = mysql_fetch_array($totalresult);
print "Total : $totalrow[0]";
--Mike Norton
-Original Message-
From: bryan
