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 "<P>Total : $totalrow[0]</P>";
--Mike Norton
-----Original Message-----
From: bryan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 14, 2001 1:56 PM
To: db
Subject: [PHP-DB] subtotal
Good day all...
Does anyone know how, if I have a "*.00" at the, I can just leave that on?
When I round, it does round,
but, if I have a total of $13.00, I want it to read ($13.00) not ($13).
here is my weak, but working code...
****************************************************************************
************
$totalsql = "SELECT SUM(total) FROM entry WHERE user_id='$passedid'";
$totalresult = mysql_query($totalsql);
$totalrow = mysql_fetch_array($totalresult);
print "<P>Total : ".round($hoursrow[0], 2)."</P>";
****************************************************************************
***********
thanks...
Bryan Fitch
Programmer
Concept Factory
[EMAIL PROTECTED]
http://www.concept-factory.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]