echo sum() problem

[dannybrazil]

Hello

I have this :

$q = "SELECT SUM(total)  FROM account";

 

now I want to echo the sum() on the screen, how do I do that ?

 

$q=mysql_query($q);

 

echo $q;

 

?

[wildteen88]

To get your results from your query you need to use ond of the mysql_fetch_* functions, such as mysql_fetch_assoc. This function will return each row as an associative array

 

$query = "SELECT SUM(total)  FROM account";
$result = mysql_query($query);

while($row = mysql_fetch_assoc($result))
{
    echo $row['SUM(total)'];
}

[Andy-H]

You can also use MySQL Aliases like so:

$query = "SELECT SUM(total) AS sumTotal  FROM account";
$result = mysql_query($query);

while($row = mysql_fetch_assoc($result))
{
    echo $row['sumTotal'];
}