How to multiply or add all numbers in a mysql column ?

chrisdee

Hello. I wonder how I can multiply or add all numbers in a
mysql column with PHP ?

devinemke

chrisdee

I only get the message :
Fatal error: Call to undefined function: sum(), when I try to use sum in my script below :

What's wrong ?

<? 
echo "<table cellpadding=4 cellspacing=0 border=1>"; 
echo "<tr>"; 

echo "<td bgcolor=lightgrey>Kode</td>"; 
echo "<td bgcolor=lightgrey>Navn</a></td>"; 
echo "<td bgcolor=lightgrey>Vekttall</a></td>"; 
echo "<td bgcolor=lightgrey>Studiepoeng</a></td>"; 
echo "<td bgcolor=lightgrey>Endre/Slett</td>"; 
echo "</tr>"; 

include("config.php"); 

$order=$_GET['order']; 
if(!$order) { 
$order="id"; 
} 

$sql_result = mysql_query("SELECT * FROM $tabell order by $order asc"); 
$loop = mysql_num_rows($sql_result); 

for ($i=0; $i<$loop; $i++) { 
$myrow = mysql_fetch_array($sql_result); 
$fag_kode = $myrow["fag_kode"]; 
$fag_navn = $myrow["fag_navn"]; 
$fag_vekttall = $myrow["fag_vekttall"]; 
$fag_studiepoeng = $myrow["fag_studiepoeng"]; 
$id = $myrow["id"]; 

echo "<tr>"; 
echo "<td>$fag_kode</td>"; 
echo "<td>$fag_navn</td>"; 
echo "<td>$fag_vekttall</td>"; 
echo "<td>$fag_studiepoeng</td>"; 
echo "<td><a href='endre.php?id=$id'>Endre</a> | <a href='sikker.php?id=$id'>Slett</a></td>"; 
echo "</tr>"; 
} 

echo "<tr><td colspan=2>Sum</td><td>".sum($fag_vekttall)."</td><td>".sum($fag_studiepoeng)."</td><td>&nbsp</td></tr>"; 
echo "</table>"; 
?>

bodzan

Devinemke gave you a link that you should check out...

The link was about MySQL functions and not PHP functions...

So, if you are going to use these functions you should use them within MySQL query and not outside because PHP simply doesn't have them or it has differnet ones that do the same job...