[SOLVED] quick sql help

[sandrob57]

Real quick, for some reason it is displaying nothing for the donations variable.

 

$result = dbquery("SELECT SUM(donations) FROM fusion_users WHERE donations>0");

$data_donations = dbarray($result);

 

echo "Total Donations: $".$data_donations['donations']."";

[per1os]

try this:

 

echo "Total Donations: $".$data_donations['SUM(donations)']."";

 

Or this:

 

$result = dbquery("SELECT SUM(donations) Donations FROM fusion_users WHERE donations>0");
$data_donations = dbarray($result);

echo "Total Donations: $".$data_donations['Donations']."";

 

--FrosT