adding up variables from mysql_fetch_array

Riley

I want to add up all the data from a mysql_fetch_array command. Not like a mysql_num_rows type of thing where it just counts the number of rows in the database. I want to add up the data IN the rows.

anyway, I have no idea how to do this. But here's a start, maybe?

$month_select = mysql_query("SELECT * FROM calendar WHERE month = 'June' AND income > '0'");
$num = mysql_num_rows($month_select);

if($num==0)
{
print("<center><font size=3 color=red>You made no money in June. way to go, chief!</font></center>");
}
while($row = mysql_fetch_array($month_select))
{
$row[income] 

fdakfl;dlfkda I don't know.. 
}

I hate to leave this question so open-ended, but I'm completely lost. I want to add up the TOTAL income in June where income > 0. yeah.

thank you!

devinemke

SELECT SUM(income) FROM calendar WHERE month = 'June'

Riley

so how would this be done?

$income = mysql_fetch_array("SELECT SUM(income) FROM calendar WHERE month='June'");
print("Total Income in June: $income");

this gets me an error reading: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

what am I doing wrong?

thanks!

ShawnK

$query = mysql_query("SELECT SUM(income) FROM calendar WHERE month='June'"); 
$income = mysql_fetch_array($query);
print("Total Income in June: $income");

devinemke

you don't need to use mysql_fetch_array at all:

$result = mysql_query("SELECT SUM(income) FROM calendar WHERE month='June'");
echo 'Total Income in June: ' . mysql_result($result, 0);

Riley

hmm. this is very strange. now i'm getting
"Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING"

my code:

<?
include("config.php");
include("nav.php");

$result = mysql_query("SELECT SUM(income) FROM calendar WHERE month='June'"); 
echo 'Total Income in June: ' . mysql_result($result, 0);
?>

I messed around with the code a bit and now when I try taking out the "Total Income in June" bit:

<?
include("config.php");
include("nav.php");

$result = mysql_query("SELECT SUM(income) FROM calendar WHERE month='June'"); 
echo mysql_result($result, 0);
?>

I get "Fatal error: Call to undefined function: mysql_query() "