dejare el codigo porfavor si alguien sabe que podria estar mal?
<?
require 'conn.php';
mysql_select_db(player);
$query = mysql_query("SELECT * FROM player WHERE level<'99' ORDER BY level DESC LIMIT 51") or die('ERRORE!');
$query2 = mysql_query("SELECT * FROM player WHERE level<'99' ORDER BY level DESC") or die('ERRORE!');
$num = mysql_num_rows($query2);
?>
<html>
<head>
<title>
Classifica Top 50
</title>
</head>
<body>
<center>Top 50 di <? echo $num; ?></center>
<center>
<table style="table-layout: fixed;" border="1" bordercolor="red">
<thead>
<tr>
<th width="7%" align="center" style="text-align: center; align:center;"><center><span align="center" style="align: center; text-align: center;">Posizione</span></center></th>
<th width="37%"><center>Nome PG</center></th>
<th width="7%" align="center">Livello</th>
<th width="7%" align="center">Regno</th>
<th width="37%" align="right" style="text-align: right;"><span align="left">EXP</span></th>
</tr>
</thead>
<tbody>
<?
$num = mysql_num_rows($query);
$i=1;
while ($i < $num) {
$rows = mysql_fetch_array($query);
$nome = $rows['name'];
$livello = $rows['level'];
$id = $rows['id'];
$query2 = mysql_query("SELECT * FROM player_index WHERE pid1='$id'") or die('ERRORE');
$query3 = mysql_query("SELECT * FROM player_index WHERE pid2='$id'") or die('ERRORE');
$query4 = mysql_query("SELECT * FROM player_index WHERE pid3='$id'") or die('ERRORE');
$query5 = mysql_query("SELECT * FROM player_index WHERE pid4='$id'") or die('ERRORE');
$row2 = mysql_fetch_array($query2);
$row3 = mysql_fetch_array($query3);
$row4 = mysql_fetch_array($query4);
$row5 = mysql_fetch_array($query5);
$villaggio = $row2['empire'];
$villaggio2 = $row3['empire'];
$villaggio3 = $row4['empire'];
$villaggio4 = $row5['empire'];
$queryexp = mysql_query("SELECT * FROM player WHERE id ='$id'") or die('ERRORE');
$rowexp = mysql_fetch_array($queryexp);
$exp = $rowexp['exp'];
if($villaggio == '1')
{
$villaggio = "<img src='images/shin.jpg' alt='Shin' title='Shin'>";
}
if($villaggio == '2')
{
$villaggio = "<img src='images/chun.jpg' alt='Chun' title='Chun'>";
}
if($villaggio == '3')
{
$villaggio = "<img src='images/jin.jpg' alt='Jin' title='Jin'>";
}
if($villaggio == '0')
{
$villaggio = 'N/D';
}
if($villaggio2 == '1')
{
$villaggio2 = "<img src='images/shin.jpg' alt='Shin' title='Shin'>";
}
if($villaggio2 == '2')
{
$villaggio2 = "<img src='images/chun.jpg' alt='Chun' title='Chun'>";
}
if($villaggio2 == '3')
{
$villaggio2 = "<img src='images/jin.jpg' alt='Jin' title='Jin'>";
}
if($villaggio2 == '0')
{
$villaggio2 = 'N/D';
}
if($villaggio3 == '1')
{
$villaggio = "<img src='images/shin.jpg' alt='Shin' title='Shin'>";
}
if($villaggio3 == '2')
{
$villaggio3 = "<img src='images/chun.jpg' alt='Chun' title='Chun'>";
}
if($villaggio3 == '3')
{
$villaggio3 = "<img src='images/jin.jpg' alt='Jin' title='Jin'>";
}
if($villaggio3 == '0')
{
$villaggio3 = 'N/D';
}
if($villaggio4 == '1')
{
$villaggio4 = "<img src='images/shin.jpg' alt='Shin' title='Shin'>";
}
if($villaggio4 == '2')
{
$villaggio4 = "<img src='images/chun.jpg' alt='Chun' title='Chun'>";
}
if($villaggio4 == '3')
{
$villaggio4 = "<img src='images/jin.jpg' alt='Jin' title='Jin'>";
}
if($villaggio4 == '0')
{
$villaggio4 = 'N/D';
}
echo "
<tr class='rankfirst'>
<td align='center'>$i</td>
<td style='margin-left: 5px; padding-left: 5px;'>$nome</td>
<td align='center'>$livello</td>
<td align='center'>$villaggio$villaggio2$villaggio3$vi llaggio4</td>
<td align='right'>$exp</td>
</tr>
";
$i++;
}
?>
</tbody>
</table>
Created by Pierx</center>
</body>
