j'ai fait ce script mais ça ne marche pas le serveur afiche "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource"
Esque quelqu'un peut m'aidé ?
Code : Tout sélectionner
$sql1 = "SELECT id, pseudo, nom, banniere, description, hit, visite, out FROM topsites";
if ($_GET['class'] == "hit"){
$sql2 = $sql1 ." ORDER BY hit DESC";
}
if ($_GET['class'] == "visite"){
$sql2 = $sql1 ." ORDER BY visite DESC";
}
if ($_GET['class'] == "out"){
$sql2 = $sql1 ." ORDER BY out DESC";
}else{
$sql2 = $sql1 ." ORDER BY hit DESC";
}
$res = mysql_query($sql2);
$rang = 0;
while($val = mysql_fetch_array($res2)){ // parcours des resultats
$id = $val['id'];
$pseudo = $val['pseudo'];
$nom = $val['nom'];
$banniere = $val['banniere'];
$description = $val['description'];
$hit = $val['hit'];
$visite = $val['visite'];
$out = $val['out'];
$rang++ ;
echo "<tr>
<th scope=\"row\">". $rang ."</th>
<td><p>". $nom ;
if (($banniere != "")&&($banniere != "http://")){
echo "<br>
<img src=\"". $banniere ."\" width=\"485\" height=\"72\">";
}
echo "</p>
<p align=\"justify\">". $description ."</p>
<p></p></td>
<td><div align=\"center\">". $hit ."</div></td>
<td><div align=\"center\">". $visite ."</div></td>
<td><div align=\"center\">". $out ."</div></td>
</tr>";
}