<?php if(!empty($_POST["annee"])){ $an=$_POST['annee']; } $sum=(mysql_query("SELECT SUM(MTTC) FROM vente ")); $result = mysql_query($sum); ?> <center> <form id="form1" name="form1" method="post" action=""> benefice, montant, ---- "/>, " /> </form></center>
<?php $an= mysql_real_escape_string($_POST['annee']); $sum=mysql_query("SELECT SUM(MTTC) FROM vente WHERE extract(year FROM date)='$an'"); ?>
<?php $sum =mysql_query("SELECT SUM(MTTC) FROM vente WHERE extract(year FROM date)= '$an'") or die('Invalid query: ' . mysql_error()); ?>
<?php exit("SELECT SUM(MTTC) FROM vente WHERE extract(year FROM date) ='$an'"); // Devrais écrir dans ta page qqch comme : // SELECT SUM(MTTC) FROM vente WHERE extract(year FROM date)='2003' $sum=mysql_query("SELECT SUM(MTTC) FROM vente WHERE extract(year FROM date)='$an'") or die('Invalid query: ' . mysql_error()); ?>
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question<?php if(!empty($_POST["annee"])){ $an=$_POST['annee']; $an=mysql_real_escape_string($_POST['annee']); } $sum=mysql_query("SELECT SUM(MTTC) FROM vente WHERE extract(year FROM date)='$an'") or die('Invalid query: ' . mysql_error()); $result = mysql_query($sum); ?> <center> <form id="form1" name="form1" method="post" action=""> benefice, montant, ---- "/>, " /> </form></center>
<?php $an = null; if(!empty($_POST["annee"])) { // A SUPPRIMER : $an=$_POST['annee']; $an=mysql_real_escape_string($_POST['annee']); } $sum=mysql_query("SELECT SUM(MTTC) FROM vente WHERE extract(year FROM date)='$an'") or die('Invalid query: ' . mysql_error()); // A SUPPRIMER : $result = mysql_query($sum); ?>
"SELECT SUM(MTTC), extract(year FROM date) AS myyear FROM vente WHERE myyear ='$an'"
0 | 1 Ta somme | L'année
" />
<?php $an = null; if(!empty($_POST["annee"])){ $an=$_POST['annee']; $an=mysql_real_escape_string($_POST['annee']); } $sum=mysql_query("SELECT SUM(MTTC), extract(year FROM date) AS myyear FROM vente WHERE myyear='$an'"); ?> <center> <form id="form1" name="form1" method="post" action=""> benefice, montant, ---- "/>, " /> </form></center>
<?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`)='$an'") or die("Erreur SQL : " . mysql_error()); ?> <center> <form id="form1" name="form1" method="post" action=""> benefice, montant, ---- "/>, " /> </form></center>