[PHP-DB] Sum Columns

[mike]

Hello,

I've been experimenting with adding decimal columns. From the mysql docs I
got this SELECT sum(value) FROM pets;

So I did this  $result = mysql_query("SELECT sum(value) FROM pets",$db);
                        $myrow = mysql_fetch_array($result);
        print "$myrow[value]";
I also tried $myrow[sum].

How can I get the sum displayed?

Thanks in advance,
Mike


-- 
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]