erreur mysql-fetch_array dans une boucle While
Message erreur
Code:
1
2
|
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\program files\easyphp1-8\www\tentative\fr\particulier\p_d\voir\essai1.php on line 14 |
Ligne 14 :
Code:
1
2
|
while($donnees = mysql_fetch_array($reponse)){ |
code complet
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
|
<? session_start(); ?>
<?
$db = mysql_connect("localhost","root","");
mysql_select_db("essai");
$id = 4;
$sel_1 = "SELECT num_menu FROM fr_part_demande WHERE num_session = $id";
$req_2 = mysql_query($sel_1,$db);
$res_a = mysql_result($req_2,'num_menu');
$sel_2 = "SELECT num_demande FROM fr_part_demande WHERE num_session = $id";
$req_1 = mysql_query($sel_2,$db);
$res_b = mysql_result($req_1,'num_demande');
$sql ="SELECT a.categorie,a.num_menu,b.num_demande,b.quantite_totale,b.prix_variant FROM fr_menu_cat a, fr_calcul_qte_pr_variant b WHERE a.num_demande = b.num_demande AND a.num_menu = $res_a AND b.num_demande = $res_b";
$reponse = mysql_query($sql,$db);
while($donnees = mysql_fetch_array($reponse)){
?>
<html>
<head>
</head>
<body>
<div id="Layer14" style="position:absolute; width:218px; height:115px; z-index:13; left: 208px; top: 25px;">
<table border="1">
<tr><th colspan="3" align="center">Vos Demandes</th></tr>
<tr>
<td align="center" bgcolor="#669999"><b>Catégorie</b></td>
<td align="center" bgcolor="#669999"><b>Quantité Totale</b></td>
<td align="center" bgcolor="#669999"><b>Prix Variant</b></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><b><? echo $donnees['categorie'];?></b></td>
<td bgcolor="#FFFFFF"><b><? echo $donnees['quantite_totale'];?></b></td>
<td bgcolor="#FFFFFF"><b><? echo $donnees['prix_variant'];}?></b></td>
</tr>
</table>
</div>
</body>
</html> |
