1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
|
<?php
$an = null;
if(!empty($_POST["annee"]))
{
$an=mysql_real_escape_string($_POST['annee']);
}
$sum=mysql_query("SELECT SUM(MTTC) FROM vente WHERE EXTRACT(YEAR FROM date_facture)='$an'") or die("Erreur SQL : " . mysql_error());
$a=mysql_result($sum,0);
$sum1=mysql_query("SELECT SUM(MTTC) FROM achat WHERE EXTRACT(YEAR FROM date_facture)='$an'") or die("Erreur SQL : " . mysql_error());
$b= mysql_result($sum1,0);
$sum2=mysql_query("SELECT SUM(montant) FROM frais WHERE EXTRACT(YEAR FROM date_facture)='$an'") or die("Erreur SQL : " . mysql_error());
$c= mysql_result($sum2,0);
$tot=$a-$b-$c;
?>
<p> </p>
<p> </p>
<center>
<form id="form1" name="form1" method="post" action="">
<table width="100" border="0" cellspacing="1" cellpadding="2" bgcolor="#7793AE">
<tr><td width="100"><div align="center" class="Style4">benefice</div></td>
<td width="100"><div align="center" class="Style4">montant</div></td></tr>
<tr><td><input type="text" name="ben" value=" benefice<?php echo $an ?>"/></td>
<td><input type="text" name="mnt" value=" <?php echo mysql_result($tot, 0);?>" /></td>
</tr>
</table>
<input name="enreg_an" type="submit" value="enregistrer" />
</form></center> |
Partager