il y a une erreur qui m'affiche: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/free.fr/4/d/unrealcheater/vgproject/game_info.php on line 32 lorsque je charge ma page. Je suis sur free.fr
Quelqu'un voit l'erreur la dedans, car j'en ai vraiment, mais vraiment besoin!
<html>
<head>
<title>Informations</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#6699cc" text="#000000">
<?php
require ("config.php" );
$dbh= mysql_connect ("$mysql_host", "$mysql_user", "$mysql_pass" )
or die ('I cannot connect to the database.');
mysql_select_db("$mysql_dbname", $dbh);
?>
<?php
$resultID = mysql_query("SELECT * FROM `game_info` WHERE `id`='$id'", $dbh);
while ($row = mysql_fetch_array($resultID))
{
$name="$row[game]";
$image="$row[splash_image]";
$players="$row[players]";
$system="$row[system]";
$publisher="$row[publisher]";
$genre="$row[genre]";
$release="$row[release]";
$esrb="$row[ESRB]";
}
?>
<?php
$resultID = mysql_query("SELECT * FROM `news` WHERE `id`='$viewid'", $dbh);
while ($row = mysql_fetch_array($resultID))
{
$headline="$row[headline]";
$description="$row[description]";
}
?>
<?php
$resultID2 = mysql_query("SELECT * FROM `reviews` WHERE `game`='$game'", $dbh);
while ($row = mysql_fetch_array($resultID2))
{
$total="$row[graphics_rate]+$row[sound_rate]+$row[gameplay]+$row[story_rate]+$row[fun_rate]";
$rating="$total/50";
}
?>
<?php
$resultID2 = mysql_query("SELECT * FROM `reviews` WHERE `game`='$game'", $dbh);
while ($row = mysql_fetch_array($resultID2))
{
$graphrate=$row[graphics_rate];
$soundrate=$row[sound_rate];
$gameplrate=$row[gameplay_rate];
$storyrate=$row[story_rate];
$funrate=$row[fun_rate];
$total=$graphrate+$soundrate+$gameplrate+$storyrate+$funrate;
$rating=$total/50*10;
}
?>
<center><?php print "$name"; ?><br><?php if ($image == "none" ) {print "<img src=\"template_images/noimage.gif\">";} else {print "<img src=\"$image\">";} ?>
<br><br>Nom: <?php print "$name"; ?><br>
Développeur: <?php print "$publisher"; ?><br>
Genre: <?php print "$genre"; ?><br>
Joueurs: <?php print "$players"; ?><br>
Sortie: <?php print "$release"; ?><br>Plateforme: <?php print "$system"; ?><br><br>
<b>A propos de <?php print "$name"; ?>:</b><br><a href='http://membres.lycos.fr/unrealcheater2/uc/?temp_view=search.php&searchstring=<?php print "$name"; ?>'>Rechercher des jeux similaires à <?php print "$name"; ?></a><br><a href='http://unrealcheater.free.fr/archives.php?recherche=1&mots_news=<?php print "$name"; ?>'>Rechercher dans les news: <?php print "$name"; ?></a><br><a href='http://ewebmaster.free.fr/galerie/?dir=/<?php print "$name"; ?>'>Verifier la présence d'une galerie d'image pour le jeu: <?php print "$name"; ?></a><br><br>
<?php print "$description"; ?>
<br><br>
<b>Disponible pour ce jeu:</b><br>
<?php
require ("config.php" );
$dbh= mysql_connect ("$mysql_host", "$mysql_user", "$mysql_pass" )
or die ('I cannot connect to the database.');
mysql_select_db("$mysql_dbname", $dbh);
$resultID2 = mysql_query("SELECT * FROM `reviews` WHERE `game`='$game'", $dbh);
while ($row = mysql_fetch_array($resultID2))
{
$id="$row[id]";
$nam="$row[game]";
$visuals="$row[graphics]";
$sound="$row[sound]";
$gameplay="$row[gameplay]";
$story="$row[story]";
$fun="$row[fun]";
$conclusion="$row[conclusion]";
$graphrate="$row[graphics_rate]";
$soundrate="$row[sound_rate]";
$gameplrate="$row[gameplay_rate]";
$storyrate="$row[story_rate]";
$funrate="$row[fun_rate]";
$total=$graphrate+$soundrate+$gameplrate+$storyrate+$funrate;
$rating=$total/50*10;
print "<a href=\"?temp_view=review.php&id=$id\">Lire le Test</a> (Note: $rating/10 )<br>";
}
if ($nam == "" ) { print "Aucun Test<br>"; }
?>
<?php
$resultID2 = mysql_query("SELECT * FROM `previews` WHERE `game`='$name'", $dbh);
while ($row = mysql_fetch_array($resultID2))
{ $game2="$row[game]";} if($game2 == "" ) {print "Aucun Preview<br>";} else {print "<a href=\"?temp_view=preview.php&game=$name\">Lire le Preview</a><br>"; }
?><?php
$resultID2 = mysql_query("SELECT * FROM `cheats` WHERE `game`='$name'", $dbh);
while ($row = mysql_fetch_array($resultID2))
{ $idg="$row[id]";
$game2="$row[game]"; } if($game2 == "" ) {print "Aucun Code, Truc ou Astuce<br>";} else {print "<a href=\"?temp_view=cheats.php&idg=$idg\">Consulter les Codes, Trucs et Astuces de jeu</a><br>"; }
?>
<?php
require ("config.php" );
$dbh= mysql_connect ("$mysql_host", "$mysql_user", "$mysql_pass" )
or die ('I cannot connect to the database.');
mysql_select_db("$mysql_dbname", $dbh);
$resultID2 = mysql_query("SELECT * FROM `guides` WHERE `game`='$game'", $dbh);
while ($row = mysql_fetch_array($resultID2))
{
$nam="$row[game]";
$id="$row[id]";
print "<a href=\"?temp_view=guide.php&id=$id\">Consulter la soluce de ce jeu</a><br>";
}
if ($nam == "" ) { print "Aucune soluce<br>"; }
?>
</body>
</html>
---------------
www.failqc.com : FailBlog québécois
