any one knows about SUM in sql ???

[thejokers]

that is not working I CANT GET $total !!!! :unsure:

 

$query4="SELECT SUM(Montant) AS total FROM t_debiteurs

WHERE Idx='$IdxDebiteur' ";

 

$result4=mysql_query($query4);

 

$ii=0;

 

while ($row4=@mysql_fetch_array($result4)) {

 

$ii++;

 

$total[$ii]= $row4['total'];

 

echo ("

 

<tr>

<td></td>

<td></td>

<td></td>

<td><div align='center'>$total</div></td>

<td><div align='center'></div></td>

<td><div align='center'></div></td>

<td></td>

</tr>

");

}