[SOLVED] Why does "SUM" return nothing?

[Moron]

My first query returns the following results:

 

The query itself is:

 

$RESULTDS=mssql_query("SELECT DV.[FY], DV.[EmpNo], DV.[NAME], DV.[EmpNo], M2.[NAMEL], M2.[NAMEF], M2.[NAMEMI], M2.[MSSNO], DV.[DATE OF SERVICE], DV.[^], DV.[sER(D-O-V-H)], DV.[CONSIDER], DV.[REIMBURSE] FROM DentalVisionHearing DV JOIN MASTERL2 M2 ON M2.[EMPNO]=DV.EmpNo

WHERE M2.[MSSNO] = '".$_SESSION['password']."' and DV.[FY] = '$fiscal' 

ORDER BY DV.[FY] desc");

 

But when I try to sum the Amount Spent column (the "CONSIDER" field in the database), using this:

 

$sql= "SELECT SUM(CONSIDER)  FROM DentalVisionHearing DV JOIN MASTERL2 M2 ON M2.[EMPNO]=DV.EmpNo
WHERE DV.[FY] = '$fiscal'" ;
$result= mssql_query($sql); 
$row = mssql_fetch_array($result); 
echo $row['total '] ; 

 

....it gives me nothing. No errors and the above results come right up, but why isn't this returning a SUM of the values in the "consider" field?

[xyn]

try while($row = mssql_fetch_array($result)) {

echo $row['total '] ;

}

[Jessica]

Where is 'total' coming from? If you want SUM to be stored as 'total', you need to tell it so:

 

$sql= "SELECT SUM(CONSIDER) AS total FROM DentalVisionHearing DV JOIN MASTERL2 M2 ON M2.[EMPNO]=DV.EmpNo
WHERE DV.[FY] = '$fiscal'" ;
$result= mssql_query($sql); 
$row = mssql_fetch_array($result); 
echo $row['total '] ; 

[Moron]

Thanks, folks, but both of the above tactics echo nothing.

 

[akitchin]

i'm going to guess that it's one of two things:  a syntax error, or the extra space in the key:

 

$sql= "SELECT SUM(CONSIDER) AS total FROM DentalVisionHearing DV JOIN MASTERL2 M2 ON M2.[EMPNO]=DV.EmpNo
WHERE DV.[FY] = '$fiscal'" ;
$result= mssql_query($sql) or die(mssql_error());
$row = mssql_fetch_array($result);
echo $row['total'];

[Moron]

i'm going to guess that it's one of two things:  a syntax error, or the extra space in the key:

 

$sql= "SELECT SUM(CONSIDER) AS total FROM DentalVisionHearing DV JOIN MASTERL2 M2 ON M2.[EMPNO]=DV.EmpNo
WHERE DV.[FY] = '$fiscal'" ;
$result= mssql_query($sql) or die(mssql_error());
$row = mssql_fetch_array($result);
echo $row['total'];

 

That works! THANK YOU!!!

 

I added a piece into the "where" clause and that's perfect.

 

Thanks!