Bon je continue la création de ma page, j'ai une autre requête que je n'arrive pas à mettre en forme:
voici l'erreur:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /mnt/124/free.fr/0/4/sparh/Jeux/jouer.php on line 147
la ligne 147 étant:
while ($tableau=mysql_fetch_array($resultat,MYSQL_ASSOC)
et voici le code de la page:
<body bgcolor="#14285f">
<table width="100%" border="1">
<tr>
<td height="120" colspan="3" align="center" bgcolor="#000000"><img src="../Image/logo.gif" alt="Sparh Prods" width="500" height="78" longdesc="Image/logo.gif" /></td>
</tr>
<tr>
<td height="1" colspan="3" align="center" bgcolor="#000000"><table width="800">
<tr>
<td> </td>
</tr>
</table></td>
</tr>
<tr>
<td width="156" height="508" align="center" valign="top"><table width="157">
<tr>
<td height="25" align="center" id="navigation"><a href="#">Accueil</a></td>
</tr>
<tr>
<td height="25" align="center" id="navigation"><a href="#">Zone membre</a> </td>
</tr>
<tr>
<td height="25" align="center" id="navigation"><a href="#">Actualités</a></td>
</tr>
<tr>
<td height="25" align="center" id="navigation"><a href="#">Vidéos</a></td>
</tr>
<tr>
<td height="25" align="center" id="navigation"><a href="#">Musique</a></td>
</tr>
<tr>
<td height="25" align="center" id="navigation"><a href="#">Jeux</a></td>
</tr>
<tr>
<td height="25" align="center" id="navigation"><a href="#">Yetisports</a></td>
</tr>
<tr>
<td height="25" align="center" id="navigation"><a href="#">Les blagues</a> </td>
</tr>
<tr>
<td height="25" align="center" id="navigation">Les haikus </td>
</tr>
<tr>
<td height="25" align="center" id="navigation">Les textes </td>
</tr>
<tr>
<td height="25" align="center" id="navigation"> </td>
</tr>
<tr>
<td height="25" align="center" id="navigation"> </td>
</tr>
<tr>
<td height="25" align="center" id="navigation"> </td>
</tr>
<tr>
<td height="25" align="center" id="navigation"> </td>
</tr>
</table></td>
<td width="540"><?php
$jeu=$_GET['jeux'];
include"config.php";
@mysql_connect($serveur, $login, $password)or die ("impossible de se connecter");
mysql_select_db($base)or die ("impossible de se connecter a la base");
$result=mysql_query("SELECT jeux,image1,image2,texte,categorie1,categorie2,vote,adresse FROM Jeux WHERE jeux='$jeu' ");
while($row=mysql_fetch_array($result))
{
print("<h1>$row[jeux]</h1> $row[texte]<br><br>")
?>
<center><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="304" height="200" title="<?php echo $row['jeux'] ?>">
<param name="movie" value="<?php echo $row['adresse'] ?>" />
<param name="quality" value="high" />
<embed src="<?php echo $row['adresse'] ?>" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="304" height="200"></embed>
</object><p>
<a href="<?php echo $row['adresse'] ?>" onclick="popUp(this.href,'fixed',400,608);return false;" title="<?php echo $row['jeux'] ?>">Cliquez jouer à <?php echo $row['jeux'] ?> en plus grand</a></p>
<table width="304">
<tr>
<td width="62" ><div align="center"><strong>Score</strong></div></td>
<td width="59" ><div align="center"><strong>Nom</strong></div></td>
<td width="167" ><div align="center"><strong>Commentaire</strong></div></td>
</tr><?php
mysql_connect($serveur, $login, $password)or die ("impossible de se connecter");
mysql_select_db($base)or die ("impossible de se connecter a la base");
$requete = $sql = 'SELECT `Test`.*'
. ' FROM Test'
. ' WHERE (`Test`.`Jeux` =$row[jeux])'
. ' ORDER BY `Test`.`Score` DESC LIMIT 0, 8 ';
$resultat=mysql_query($requete,$id_connexion);
while ($tableau=mysql_fetch_array($resultat,MYSQL_ASSOC))
{
echo '</td><td><center>',$tableau['Score'],'</center></td>
<td><center>',$tableau['Nom'],'</center></td><td><center>',$tableau['Com'],'</center></td></tr>';
}
mysql_close();
?>
</table>
</center></td>
<td width="215"> </td>
</tr>
<tr>
<td height="108"> </td>
<td> </td>
<td> </td>
</tr>
</table>
</body>
</html><?php } ?>
Voilà, j'comprends pas car la requête marche normalement sur me site mais là elle marche plus??
ps la requête:
<?php
mysql_connect($serveur, $login, $password)or die ("impossible de se connecter");
mysql_select_db($base)or die ("impossible de se connecter a la base");
$requete = $sql = 'SELECT `Test`.*'
. ' FROM Test'
. ' WHERE (`Test`.`Jeux` =$row[jeux])'
. ' ORDER BY `Test`.`Score` DESC LIMIT 0, 8 ';
$resultat=mysql_query($requete,$id_connexion);
while ($tableau=mysql_fetch_array($resultat,MYSQL_ASSOC))
{
echo '</td><td><center>',$tableau['Score'],'</center></td>
<td><center>',$tableau['Nom'],'</center></td><td><center>',$tableau['Com'],'</center></td></tr>';
}
mysql_close();
