1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
$requete = "
SELECT Year(jour_mise_en_service) as Année, SUM(cout_achat) as cout
FROM Ordinateur
Group By Année
";
$requete2 = "
SELECT Year(O.jour_mise_en_service) as Année, SUM(O.cout_achat) as cout2
FROM Ordinateur O, renouvellement R
WHERE R.nom_ordi=O.nom
Group By Année
";
$resultat = mysql_query($requete) or die(mysql_error());
$resultat2 = mysql_query($requete2) or die(mysql_error());
print "<ul>";
while ($nuplet = mysql_fetch_assoc($resultat)) {
$data = $nuplet['cout']+$nuplet['cout2'];
print $data " ".$nuplet['Année'];
print "</li>";
}
print "</ul>"; |
