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
| <?php require_once('Connections/Bulletins.php'); ?>
<?php
mysql_select_db($database_Bulletins, $Bulletins);
$query_MoyennePonderee = "SELECT bulluc_2006_2007_eleves.nom, SUM(bulluc_2006_2007_bulletin_1.TOTAL*bulluc_2006_2007_matieres.heures) AS pondere, SUM(bulluc_2006_2007_matieres.heures) AS heures FROM bulluc_2006_2007_bulletin_1 JOIN bulluc_2006_2007_eleves ON bulluc_2006_2007_eleves.id = bulluc_2006_2007_bulletin_1.eleve JOIN bulluc_2006_2007_matieres ON bulluc_2006_2007_matieres.id = bulluc_2006_2007_bulletin_1.cours GROUP BY bulluc_2006_2007_eleves.id";
$MoyennePonderee = mysql_query($query_MoyennePonderee, $Bulletins) or die(mysql_error());
$row_MoyennePonderee = mysql_fetch_assoc($MoyennePonderee);
$totalRows_MoyennePonderee = mysql_num_rows($MoyennePonderee);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Document sans titre</title>
</head>
<body>
<table border="1">
<tr>
<td>Eleve</td>
<td>pondere</td>
<td>classe</td>
</tr>
<?php do { ?>
<?php } while ($row_MoyennePonderee = mysql_fetch_assoc($MoyennePonderee)); ?>
</body>
</html>
<?php mysql_free_result($MoyennePonderee);?> |
Partager