Simple Sum not working

[muddy004]

Dear Freaks,

 

This is an odd question.  I've inherited a very old php application.  I attempted to upgrade it.  The application is used to add certain columns of data.  On the original server, three columns add just fine (output to a report).  On the upgraded server (newer mysql and php), the report displays zero for the three columns.

 

This is the code for adding the three columns:

 

# locations
      $sql_locs = "SELECT sum(C1NearHome)+sum(C2NearHome)+sum(C3NearHome),
      sum(C1NearWork)+sum(C2NearWork)+sum(C3NearWork), sum(C1NearSchool)+sum(C2NearSchool)+sum(C3NearSchool) FROM request WHERE YMDHMS >= $bgnDate AND YMDHMS <= $endDate";
      $res_locs = mysql_query($sql_locs);
      $nrow_locs = mysql_num_rows($res_locs);
      if ($nrow_locs > 0) {
         $row_locs = mysql_fetch_row($res_locs);
         $stats[$stindx . "nearHome"] = $row_locs[0];
         $stats[$stindx . "nearWork"] = $row_locs[1];
         $stats[$stindx . "nearSchool"] = $row_locs[2];
      }

 

This line: 

sum(C1NearSchool)+sum(C2NearSchool)+sum(C3NearSchool)

isn't adding correctly.  The report on the new server shows zero, but on the old server, for example, the number is 4.  If I remove two of the sums and make it:

sum(C1NearSchool)

 

the report displays the total for that column.  When I add the two other sums back to the equation, I get zero again.

 

Any ideas what's wrong here?

 

Any help is greatly appreciated.

 

 

[revraz]

Maybe try something like..

 

$sql_locs = "SELECT (sum(C1NearHome)+sum(C2NearHome)+sum(C3NearHome)),

      (sum(C1NearWork)+sum(C2NearWork)+sum(C3NearWork)), (sum(C1NearSchool)+sum(C2NearSchool)+sum(C3NearSchool)) FROM request WHERE YMDHMS >= $bgnDate AND YMDHMS <= $endDate";

     

If that doesn't work, post in the MySQL forum, Fenway probably knows.

 

[clearstatcache]

how about this...

 

$sql_locs = "SELECT sum(C1NearHome+C2NearHome+C3NearHome),

      sum(C1NearWork+C2NearWork+C3NearWork), sum(C1NearSchool+C2NearSchool+C3NearSchool)  FROM request WHERE YMDHMS >= $bgnDate AND YMDHMS <= $endDate";

     

[muddy004]

Thank for the try.  Unfortunately, these fixes didn't work.

 

I'll try the mysql forums.

 

thanks