here's my query.

$result = mysql_query("SELECT SUM(DAY+NIGHT) AS TOTALTIME FROM MAIN", $db);
$myrow = mysql_fetch_array($result);
extract ($myrow);
echo ("<br>$TOTALTIME<br>");

In my database, Night = 1.2 and Day = 0.7

The answer should come up as 1.9 right?
Well,
I'm getting:

1.9000000357628


The first couple of decimal points are always correct, but then i get a bunch of numbers in the back

any clude why?
thanks
Noam

You are always going to find a certain amount of imprecision in any floating point calculation. (Even those performed by your trusty pocket calculator.)

This includes: imprecision during the calculation; truncation that can occur when storing the value in memory areas of various sizes; errors that occur in translating your character input into binary; and errors which occur in translating the binary data to decimal characters for your viewing pleasure!

It's normal. Every computer application, not just MySQL, exhibits this behavior.