requête de jointure plusieurs table
bonjour,
comment fait une requête qui jointe plusieurs table, j'ai une formulaire qui normalement l'utilisateur choisit le module,filière,année, groupe et le type de la note cette formulaire normalement permit d'afficher la liste des étudiant qui sont inscris dans le module, le groupe,..... choisis aideriez-moi pour faire la requête
le code de la premier formulaire est
Code:
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
|
<table width="200" border="0" align="center" cellpadding="0" cellspacing="0" background="../../image/fbg.jpg" id="rechrche_saisie_form">
<tr>
<td height="30"> </td>
</tr>
<tr>
<td><table width="200" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="77"><span class="style21">Module :</span></td>
<td width="123"><label>
<select name="menu_module" id="menu_module">
<?php
do {
?>
<option value="<?php echo $row_rs_module['m_code']?>"><?php echo $row_rs_module['m_nom']?></option>
<?php
} while ($row_rs_module = mysql_fetch_assoc($rs_module));
$rows = mysql_num_rows($rs_module);
if($rows > 0) {
mysql_data_seek($rs_module, 0);
$row_rs_module = mysql_fetch_assoc($rs_module);
}
?>
</select>
</label></td>
</tr>
<tr>
<td>Filière :</td>
<td><label>
<select name="menu_filiere" id="menu_filiere">
<?php
do {
?>
<option value="<?php echo $row_rs_filiere['f_code']?>"><?php echo $row_rs_filiere['f_nom']?></option>
<?php
} while ($row_rs_filiere = mysql_fetch_assoc($rs_filiere));
$rows = mysql_num_rows($rs_filiere);
if($rows > 0) {
mysql_data_seek($rs_filiere, 0);
$row_rs_filiere = mysql_fetch_assoc($rs_filiere);
}
?>
</select>
</label></td>
</tr>
<tr>
<td>Année :</td>
<td><label>
<select name="menu_annee" id="menu_annee">
<?php
do {
?>
<?php
} while ($row_rs_inscription = mysql_fetch_assoc($rs_inscription));
$rows = mysql_num_rows($rs_inscription);
if($rows > 0) {
mysql_data_seek($rs_inscription, 0);
$row_rs_inscription = mysql_fetch_assoc($rs_inscription);
}
?>
</select>
</label></td>
</tr>
<tr>
<td>Groupe :</td>
<td><label>
<select name="menu_groupe" id="menu_groupe">
</select>
</label></td>
</tr>
<tr>
<td>Note :</td>
<td><label>
<select name="menu_note" id="menu_note">
<option selected="selected">Controle 1</option>
<option>Controle 2</option>
<option>TD</option>
<option>TP</option>
<option>Synthese</option>
<option>Rattrapage</option>
</select>
</label></td>
</tr>
<tr>
<td> </td>
<td><label>
<input type="submit" name="button2" id="button2" value="Recherche" />
</label></td>
</tr>
</table></td>
</tr>
</table> |
le corps de la 2éme formulaire est
Code:
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
| <form action="" method="post" name="etudiant">
<input name="etape" type="hidden" value="2" />
<input name="nb_etudiant" type="hidden" value="<?php echo $_POST['nombre']; ?>" />
<table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr>
<td width="14%" bgcolor="#FFAD5B"><span class="Style5">Numero d'inscription</span></td>
<td width="10%" bgcolor="#FFAD5B"><span class="Style5">Nom de module</span></td>
<td width="11%" bgcolor="#FFAD5B"><span class="Style5">Controle1</span></td>
<td width="12%" bgcolor="#FFAD5B"><span class="Style5">Controle2</span></td>
<td width="10%" bgcolor="#FFAD5B"><span class="Style5">TD</span></td>
<td width="10%" bgcolor="#FFAD5B"><span class="Style5">TP</span></td>
<td width="12%" bgcolor="#FFAD5B"><span class="Style5">Syntyse</span></td>
<td width="11%" bgcolor="#FFAD5B"><span class="Style5">Rattrapage</span></td>
<td width="10%" bgcolor="#FFAD5B"><span class="Style5">Rapport</span></td>
</tr>
<?php for($i=0;$i<$_POST['nombre'];$i++){ ?>
<tr>
<td bgcolor="#FFF4EA"><input type="text" name="numero_inscription:<?php echo $i; ?>" value="" size="10" /></td>
<td bgcolor="#FFF4EA"><select name="m_code:<?php echo $i; ?>">
<?php
do {
?><option value="<?php echo $row_rs_module['m_code']?>"><?php echo $row_rs_module['m_nom']?></option>
<?php
} while ($row_rs_module = mysql_fetch_assoc($rs_module));
$rows = mysql_num_rows($rs_module);
if($rows > 0) {
mysql_data_seek($rs_module, 0);
$row_rs_module = mysql_fetch_assoc($rs_module);
}
?>
</select></td>
<td bgcolor="#FFF4EA"><input type="text" name="controle1:<?php echo $i; ?>" value="" size="10" /></td>
<td bgcolor="#FFF4EA"><input type="text" name="controle2:<?php echo $i; ?>" value="" size="10" /></td>
<td bgcolor="#FFF4EA"><input type="text" name="TD:<?php echo $i; ?>" value="" size="10" /></td>
<td bgcolor="#FFF4EA"><input type="text" name="TP:<?php echo $i; ?>" value="" size="10" /></td>
<td bgcolor="#FFF4EA"><input type="text" name="syntyse:<?php echo $i; ?>" value="" size="10" /></td>
<td bgcolor="#FFF4EA"><input type="text" name="rattrapage:<?php echo $i; ?>" value="" size="10" /></td>
<td bgcolor="#FFF4EA"><input type="text" name="rapport:<?php echo $i; ?>" value="" size="10" /></td>
</tr>
<?php } ?>
</table>
<div align="right">
<input type="submit" name="Submit" value="Insérer" />
</div>
</form> |
