Simple MySql and PHP question

[mrcaveman]

Hi.

How do I get the result of this qury??

$conn = db_connect();

$sql5 = "SELECT SUM(counter) FROM standardbrev WHERE produkt = '$id'";

$result5 = mysql_query($sql5, $conn);

Which function do I have to use to show the result of all the numbers in my database where "produkt" is Bricks ($id)??

Kj.

[cgraz]

$sql5 = "SELECT SUM(counter) AS sum FROM standardbrev WHERE produkt='$id'"; 
$result5 = mysql_query($sql5) or die(mysql_error()); 

$row = mysql_fetch_array($result5);
echo $row["sum"];

Cgraz