Bonjour,
Je voudrais de l'aide pour obtenir le programme qui donne la somme d'une colonne d'un tableau contenant des montants. Je n'arrive pas à afficher le montant total c'est à dire la somme totale des montants contenus dans la colonne.
Je travaille avec php et voici la strucrure de mon programme:
<?php require_once('Connections/lahat.php'); ?>
<?php
$maxRows_Recordset1 = 10;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
$pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;
mysql_select_db($database_lahat, $lahat);
$query_Recordset1 = "SELECT * FROM dépenses";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $lahat) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
if (isset($_GET['totalRows_Recordset1'])) {
$totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
$all_Recordset1 = mysql_query($query_Recordset1);
$totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>LISTE DEPENSES</title>
<style type="text/css">
<!--
.Style7 {color: #000033}
.Style11 {font-family: Geneva, Arial, Helvetica, sans-serif; font-size: 12px; }
.Style13 {color: #0000FF; font-weight: bold; font-style: italic; font-size: 36px; }
.Style14 {font-size: 24px}
body {
background-image: url(Nouveau%20dossier/DSC00237.JPG);
}
.Style15 {
color: #000099;
font-size: 18px;
}
.Style16 {
color: #696973;
font-style: italic;
font-weight: bold;
}
.Style17 {
color: #696973;
font-weight: bold;
}
-->
</style>
</head>
<body>
<p> </p>
<p align="center" class="Style13 Style14 Style15">LISTE DES DEPENSES DE FONCTIONNEMENT ET DEPENSES DIVERSES (SERVICES EXTERIEURS) </p>
<p> </p>
<p> </p>
<table width="1049" border="1">
<tr bordercolor="#0000FF" bgcolor="#E9EBFE">
<td width="137"><div align="center" class="Style16">DATE</div></td>
<td width="490"><div align="center" class="Style16">NATURE DE LA DEPENSE </div></td>
<td width="224"><div align="center" class="Style16">MONTANT</div></td>
<td width="170"><div align="center" class="Style16">RESPONSABLE</div></td>
</tr>
<?php do { ?>
<tr bordercolor="#0000FF" bgcolor="#E9EBFE">
<td><div align="center" class="Style11"><span class="Style7"><?php echo $row_Recordset1['date']; ?></span></div></td>
<td><div align="center" class="Style11"><span class="Style7"><?php echo $row_Recordset1['nature_depense']; ?></span></div></td>
<td><div align="center" class="Style11"><span class="Style7"><?php echo $row_Recordset1['montant']; ?></span></div></td>
<td><div align="center" class="Style11"><span class="Style7"><?php echo $row_Recordset1['responsable']; ?></span></div></td>
</tr>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>
<p> </p>
<p> </p>
<p> </p>
<p>
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="
http://fpdownload2.macromedia.com/get/shockwave/cabs/flash/swflash.cab#version=5,0,0,0 " width="105" height="21" title="DS">
<param name="movie" value="button18.swf" />
<param name="quality" value="high" />
<param name="bgcolor" value="#335779" />
<embed src="button18.swf" quality="high" pluginspage="
https://get.adobe.com/flashplayer/ " type="application/x-shockwave-flash" width="105" height="21" bgcolor="#335779"></embed>
</object>
</p>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>
Merci d'avance
Afficher la suite
