Este es:
Código PHP:
<?
//incluimos el config donde estan los datos de la BD
include('config4.php');
$query = mysql_query("SELECT * from inscritos");
while($clan=mysql_fetch_array($query))
{
//pasamos a variables normales
$id = $clan["id"];
$Nickzone1 = $clan["Nickzone1"];
$Pais1 = $clan["Pais1"];
$Mail1 = $clan["Mail1"];
$Hora1 = $clan["Hora1"];
$Clan1 = $clan["Clan1"];
$Nickirc2 = $clan["Nickirc2"];
$Nickzone2 = $clan["Nickzone2"];
$Pais2 = $clan["Pais2"];
$Mail2 = $clan["Mail2"];
$Hora2 = $clan["Hora2"];
$Clan2 = $clan["Clan2"];
if ($Nickirc1!=1) {
$Nickirc1 = $clan['Nickirc1'];
}
else {
$Nickirc1=0;
}
//Se Muestra el contenido :)
echo '<table width="453" border="0" cellspacing="1" cellpadding="0" bgcolor="#000000">
<tr bgcolor="#FFFFFF">
<td rowspan="4" align="center" width="26">#' . $id . '</td>
<td width="214">Nick IRC:' . $Nickirc1 . '</td>
<td rowspan="2" align="center" width="32"><img src="flags/mini/' . $Pais1 . '.gif"></td>
<td width="54"><a href="mailto:' . $Mail1 . '">Mail</a></td>
<td width="116">Hora:' . $Hora1 . '</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="214">Nick ZONE:<a href="http://classic.zone.msn.com/Profile/RatingsPlayer.asp?Players=&Teams=&PlayerID=' . $Nickzone1 . '&TeamID=&pguest=" target="_blank">'
. $Nickzone1 . '</a></td>
<td colspan="2" bgcolor="#FFFFFF">Clan:' . $Clan1 . '</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="214">Nick IRC:' . $Nickirc2 . '</td>
<td rowspan="2" bgcolor="#FFFFFF" align="center" width="32"><img src="flags/mini/' . $Pais2 . '.gif"></td>
<td bgcolor="#FFFFFF" width="54"><a href="mailto:' . $Mail2 . '">Mail</a></td>
<td bgcolor="#FFFFFF" width="116">Hora:' . $Hora2 . '</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="214">Nick ZONE:<a href="http://classic.zone.msn.com/Profile/RatingsPlayer.asp?Players=&Teams=&PlayerID=' . $Nickzone2 . '&TeamID=&pguest=" target="_blank">'
. $Nickzone2 . '</a></td>
<td colspan="2" bgcolor="#FFFFFF">Clan:' . $Clan2 . '</td>
</tr>
</table>';
}
?>