Consultation des achats

Accueil
Consultation des comptes d'."'".'achats

'; include"connection.php3"; mysql_select_db($login,$connection); $table=mysql_query("select * from achat",$connection); $cpt_achat=mysql_num_rows($table); if($cpt_achat!=0){ $cpt=0; $total_achat=0; print'Compte : 60 Achats

'; while($cpt<$cpt_achat){ print''; print''; print''; print''; print''; print''; $total_achat+=mysql_result($table,$cpt,Montant); $cpt++; } } mysql_close($connection); print'

Motif Montant Règlement Date Mail Exercice
'; print mysql_result($table,$cpt,Motif); print' '; print mysql_result($table,$cpt,Montant); print' '; print mysql_result($table,$cpt,Mode); print' '; print mysql_result($table,$cpt,jour); print' '; print mysql_result($table,$cpt,Mail); print' '; print mysql_result($table,$cpt,Exercice); print'

Montant total des achats : '.$total_achat.' € '; ?>

Motif	Montant	Règlement	Date	Mail	Exercice
'; print mysql_result($table,$cpt,Motif); print'	'; print mysql_result($table,$cpt,Montant); print'	'; print mysql_result($table,$cpt,Mode); print'	'; print mysql_result($table,$cpt,jour); print'	'; print mysql_result($table,$cpt,Mail); print'	'; print mysql_result($table,$cpt,Exercice); print'