SQL sum und where

[artemisia]

----------------------------------------------
mysql_connect("xxx","xxx","xxx");
mysql_select_db("datenbank");
$result = mysql_query("SELECT SUM(brutto) FROM spalte1 WHERE spalte2 = *text*");
for($i=0; $i<mysql_num_rows($result); $i++) {
$id = mysql_result($result,$i,0);
echo "<font color=#3399FF>Textdererscheint:</font> $id Summe "
;
}
-------------------------------------------------

greetz
artemisia