Help with SUM Command

[PHPNEWTOIT]

Hi

 

I have a database table called 2004_English and a table called Male which hold lots fo numbers. I want to calculate the SUM of all the numbers in the table but cant seem to get it to work.

 

I have tried many alternatives but it comes back with either Array or wont run at all.

 

Here is the code I have been playing with:-

 

<?php
    $query = "SELECT SUM(`2004_English`.Male) FROM `2004_English`";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)){
echo "$row \n";
}
?>

 

 

[trq]

<?php
    $query = "SELECT SUM(Male) FROM 2004_English";
    $result = mysql_query($query) or die(mysql_error());
    $row = mysql_fetch_row($result);
    echo $row[0];
?>

[The Little Guy]

You know sum adds up numbers right?

 

For some reason (I could be wrong), but it sounds like COUNT() feels more appropriate (but I haven't seen what the column "Male" holds). COUNT counts the number of rows returned... from your where clause (if you have one).

 

    $query = "SELECT SUM(`Male`) as maleSum FROM 2004_English";
    $result = mysql_query($query) or die(mysql_error());
    $row = mysql_fetch_array($result);
    echo $row['maleSum'];