on peut pas utiliser la meme requete deux fois de suite ??
ça donne ça :$sql = "SELECT * FROM planetes WHERE players=".$_SESSION['id_user']."";
$req = mysql_query($sql) or die(mysql_error());
if (mysql_num_rows($req)==0) echo("Vous ne possédez pas de planètes !");
else
{
echo("<table width=400 align=center cellpadding=0 class=txt-biens cellspacing=1 bgcolor=#51260B><tr align=center style=\"padding-left: 25px; padding-top: 5px; padding-bottom: 5px;\" class=txt-tab-recap><td width=100 height=15>Planètes</td><td width=100>Salaire</td><td width=100>Unités</td><td width=100>Infrastructures</td></tr>");
while (list($id, $nom, $zone, $players, ...) = mysql_fetch_row($req))
{
...
}
echo("</table><br>");
}
$sql = "SELECT * FROM planetes WHERE players=".$_SESSION['id_user']."";
$req = mysql_query($sql) or die(mysql_error());
if (mysql_num_rows($req)==0) echo("Vous ne possédez pas de planètes !");
else
{
while (list($id, $nom, $zone, $players, ...) = mysql_fetch_row($req))
{
...
}
}
