Ma requete s'arrete apres 15 requete array est ce normal et comment faire pour en ajouter plus...? merci
Voilà le message d'erreur
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /homez.187/youresto/www/fiche.php on line 20
ligne correspond à l'array
Merci
Code : Tout sélectionner
1. $id_resto=$_GET["id"];
2. $query_exists = mysql_query("SELECT COUNT(id) FROM resto WHERE id='$id_resto'" );
3. $result_exists = mysql_fetch_row($query_exists);
4. if ($result_exists[0]==0)
5. {
6. header("HTTP/1.1 301 Moved Permanently" );
7. header("Location: index.php" );
8. die("Redirection" );
9. }
10. else
11. {
12. // champs à sélectionner / à afficher
13. $tab_champs = array("id","title","city","note","description","address","phone","website","cap","menu_entree","menu_plat","menu_dessert","youtube_link","resa","horferm","pain" );
14. $chr_champs='';
15. foreach($tab_champs as $val) $chr_champs.=$val.', ';
16. $chr_champs=substr($chr_champs,0,-2);
17. $q = mysql_query("SELECT $chr_champs FROM resto WHERE id='$id_resto'" );
18. $r = mysql_fetch_assoc($q);
19. $quser = mysql_query('SELECT id_user FROM users_restos WHERE id_resto=\'' . $r['id'] . '\'');
20. $ruser = mysql_fetch_assoc($quser);
21. }
22.
23. // mise a jour des affichages du resto
24. mysql_query("UPDATE resto SET hits=hits+1 WHERE id='$id_resto'" );
25.
26. if ($_SESSION["config_user"]["id_user"]>0 && $_SESSION["config_user"]["id_user"]!=$ruser["id_user"] && $_SESSION["fiche_"."$id_resto"]!="visited" )
27. {
28. $qf = mysql_query("SELECT fiche FROM fidelite_config" );
29. $rf = mysql_fetch_assoc($qf);
30. mysql_query("UPDATE users_fidelite SET fiche=fiche+'".$rf["fiche"]."' WHERE id_user='".$_SESSION["config_user"]["id_user"]."'" );
31. mysql_query("UPDATE users SET points=points+".$rf["fiche"]." WHERE id_user='".$_SESSION["config_user"]["id_user"]."'" );
32. mysql_query("INSERT INTO fidelite_log SET id_user='".$_SESSION["config_user"]["id_user"]."', type='fiche', points='".$rf["fiche"]."', date=NOW()" );
33. $_SESSION["fiche_"."$id_resto"]="visited";
34. }
35. ?>
36. .......................////////////
37. ///////............................
38.
39. <p id="logo"><a href="index.php" title="Trouvez votre restaurant avec Youresto.com"><img src="logo.png" alt="Bienvenue sur Youresto.com"></a></p>
40. <? include("search.inc.php" ); ?>
41. <h2 id="total">Restaurant à <strong><?=$r["$tab_champs[2]"];?> Restaurant <?=$r["$tab_champs[1]"];?> </strong></h2>
42. <table width="100%" cellpadding="0" cellspacing="0" border="0" id="tfiche">
43. <tr>
44. <td style="vertical-align:top;">
45. <div id="details2">
46.
47. <h1>Restaurant à <?=$r["$tab_champs[2]"];?><br /><?=$r["$tab_champs[1]"];?> </h1>
48. <?
49. if(trim($r["youtube_link"])!='')
50. {
51. ?>
52. <div id="video">
53. <object width="400" height="260"><param name="movie" value="<?=$r["youtube_link"];?>"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><param name="wmode" value="transparent" /></param><embed src="<?=$r["youtube_link"];?>" type="application/x-shockwave-flash" allowscriptaccess="always" wmode="transparent" allowfullscreen="true" width="400" height="260"></embed></object>
54. </div>
55. <?
56. }
57. ?>
58. <?
59. if ($r["$tab_champs[4]"]!='')
60. {
61. echo '<h3>'.stripslashes($r["$tab_champs[4]"]).'</h3>';
62. }
63. else
64. {
65. echo '<h3 class="underline">aucune description disponible</h3>';
66. }
67. ?>
68. <br /><br />
69. <div id="adr"><strong>Adresse:</strong><br /><?=$r["$tab_champs[5]"];?><br /><?=$r["$tab_champs[8]"];?> <?=$r["$tab_champs[2]"];?>
70.
71. <p><span class="vio">Appeler le Restaurant: </span><?=format_champvide($r["$tab_champs[6]"],'nr');?></p>
72. <p><span class="vio">Site Internet du Restaurant: </span><?=format_champvide($r["$tab_champs[7]"],'nr');?></p><br>
73. <p><span class="vio">Horaires: </span><?=format_champvide($r["$tab_champs[14]"],'nr');?></p><br>
74. <p><span class="vio">Qualité du pain: </span><?=format_champvide($r["$tab_champs[15]"],'nr');?></p>
75.
76. </div>
77. <div id="commentaires">
78. <h1>Commentaires sur le restaurant</h1>
79. <?
80. $qc = mysql_query("SELECT COUNT(id_commentaire) FROM commentaires WHERE id_resto='$id_resto' AND valid='y'" );
81. $rc = mysql_fetch_row($qc);
82. if ($rc[0]>0)
83. {
84. $qc = mysql_query("SELECT * FROM commentaires WHERE id_resto='$id_resto' AND valid='y' ORDER BY date DESC" );
85. while ($rc = mysql_fetch_assoc($qc))
86. {
87. ?>
88. <div class="commentaire">
89. <p class="qui vio">» <strong><?=htmlentities($rc["pseudo"]);?></strong>, le <?=format_date($rc["date"]);?></p>
90. <p class="com"><?=htmlentities(stripslashes($rc["commentaire"]));?></p>
91. </div>
