Divers

 // Affichage des objets classement 1.
 
 
 
$objet1query = "SELECT * FROM  rpg_items";
 
 
 
$res= mysql_query($objet1query);
 
$i=0;
 
 
 
while($row = mysql_fetch_row($res)){
 
 
 
 
 
$tabl[$i]=$row[0];
 
$tabl[$i]=$row[1];
 
$tabl[$i]=$row[2];
 
$tabl[$i]=$row[3];
 
$tabl[$i]=$row[4];
 
$tabl[$i]=$row[5];
 
$tabl[$i]=$row[6];
 
 $i++; 
 
 }
for ($count1=0 ;$count1<count($tabl);$count1++) {
$sql= "SELECT u.weaponname, count(u.weaponid) as occurences, i.buycost, i.image, i.special  FROM rpg_users AS u, rpg_items AS i WHERE u.weaponid >= 0 AND i.id = u.weaponid GROUP BY u.weaponid ORDER by occurences DESC ";

and id=$tabl[$i][0]; 


$res= mysql_query($sql);
while($row = mysql_fetch_row($res)){
 
 

$weapon .='<table border="0" height="40"><tr><td><img src="images/objets/'. $row['image'].'.jpg" title="' . $row['weaponname'] . '"/></td>

          <td><b>Nom: </b><span class="rose3">' . $row['weaponname'] . '</span><br><b>Prix: </b><span class="rose3">' . $row['buycost'] . ' rubis</span><br><b>Equipé: </b><span class="rose3">... perso.</span><br></td></tr></table>';
 
}//end while
}