doing more math in a query

[sysadmin42]

Hi. here's the code:

$result=doQuery("SELECT high_estimate,low_estimate FROM projects WHERE status IN (SELECT id FROM project_status WHERE name LIKE '%In Progress%')");
while ($line=mysql_fetch_assoc($result)) { 
  $high+=$line['high_estimate']; 
  $low+=$line['low_estimate']; 
}

This gives me exactly what I want: the sums of 'high_estimate' and 'low_estimate' for items that match the subquery.

Is there a way to get all that into the query? or at the very least simplify my PHP?

The first thing I tried was:

SELECT SUM(high_estimate) AS high_estimate FROM projects WHERE status IN (SELECT id FROM project_status WHERE name LIKE '%In Progress%');

but it kept giving me errors. Any thoughts?

 

[sleipnir214]

it kept giving me errors" is pretty vague.



Want the best answers? Ask the best questions! TANSTAAFL!

 

[sysadmin42]

well, I just tried the query again and although it didn't work right, it also didn't give me any errors.

but my real question is: Is there any way to simplify the first block of code?