rendered paste body // 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++) {
$count1=count($tabl); echo $count1;
$objets1query = doquery ("SELECT weaponname, count(weaponid) as occurences FROM {{table}} WHERE weaponid >= 0 GROUP BY weaponid ORDER by occurences DESC ","users");
$res= mysql_query($objet1query);
while ($row = mysql_fetch_array($objets1query)){
$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>';
}
}