Add all mysql rows together that fit criteria

[dkin]

is there a function I can use to run a mysql query that grabs all rows in a database that fit the criteria and adds them together?

[dreamcatcher]

$query = mysql_query("SELECT SUM(row) as sum_total FROM table WHERE row = 'something'") or die(mysql_error());
$row = mysql_fetch_object($query);

echo $row->sum_total;

Think that should work ok.

dc