[SOLVED] How to total up a database column in php/mysql

[dessolator]

How do I total up a column in php/mysql I need to total 2 columns up with about 30 values then create this if statement: if Yscore > Gscore echo "Y is the winner".

 

 

Thanks,

 

Ian

[revraz]

This may help

 

http://www.tizag.com/mysqlTutorial/mysqlsum.php

[pocobueno1388]

<?php

$query = mysql_query("SELECT SUM(fld1) as Yscore, SUM(fld2) as Gscore FROM table")or die(mysql_error());
$row = mysql_fetch_assoc($query);

echo $row['Yscore'];
echo $row['Gscore'];

?>

 

 

[dessolator]

Thanks very much guys, much appreciated