Hola tengo el siguiente codigo php:
Código PHP:
set_time_limit(0);
ini_set('memory_limit', '30M');
include 'PHT.php';
$dbhost = "localhost";
$dbname = "aseh";
$dbuser = "root";
$dbpassword = "";
$HT = new CHPPConnection('nukestats', '3400', '7CAEA600-B56B-49C0-9B4D-CADE3F34C5AD', '');
$HT->connectUser('destor77','xxx');
$temporada=$HT->getWorldDetails()->getLeague(7)->getSeasonNumber();
if ( $link = mysql_connect($dbhost,$dbuser,$dbpassword) )
{
if ( mysql_select_db($dbname, $link) ){
$sql="select id_temp from aseh_temporadas order by id_temp DESC limit 1";
$result=mysql_query($sql);
$temp=mysql_fetch_array($result);
//controlo la temporada
if ($temp['id_temp']<>$temporada){
$sql="insert into aseh_temporadas (id_temp,temp) values ('".$temporada."','Temporada ".$temporada."')";
if(!mysql_query($sql)){
echo "error en agregar la temporada nueva".mysql_error()."<br>$sql";
}
}
$sql="SELECT ae.id_hattrick, nombre, ranking, posicion, estrellas, boot
FROM aseh_equipos as ae
join aseh_ranking as ar on ar.id_hattrick=ae.id_hattrick
join aseh_posiciones as ap on ap.id_hattrick=ae.id_hattrick
join aseh_division as ad on ad.id_hattrick=ae.id_hattrick
join aseh_estrellas as aest on aest.id_hattrick=ae.id_hattrick
where ad.id_temp='$temporada' group by id_hattrick
";
$result = mysql_query($sql);
echo' <div align="center">
<table width="391" height="235" border="1" cellpadding="0" cellspacing="0">';
echo '<tr>
<td colspan="4"><div align="center">id</div></td>
<td colspan="4"><div align="center">id_hattrick</div></td>
<td colspan="4"><div align="center">nombre</div></td>
<td colspan="4"><div align="center">estrellas</div></td>
<td colspan="4"><div align="center">ranking</div></td>
<td colspan="4"><div align="center">boot</div></td>
<td colspan="4"><div align="center">division</div></td>
</tr>';
while ( $row = mysql_fetch_array( $result, MYSQL_ASSOC ) ){
echo '<tr>
<td colspan="4"><div align="center">'.$i.'</div></td>
<td colspan="4"><div align="center">'.$row["id_hattrick"].'</div></td>
<td colspan="4"><div align="center">'.$row["nombre"].'</div></td>
<td colspan="4"><div align="center">'.$row["estrellas"].'</div></td>
<td colspan="4"><div align="center">'.$row["ranking"].'</div></td>
<td colspan="4"><div align="center">'.$row["boot"].'</div></td>
<td colspan="4"><div align="center">'.$row["division"].'</div></td>
</tr>';
$i++;
}// fin while $row = mysql_fetch_array( $result1, MYSQL_ASSOC )
mysql_free_result($result);
echo '</table></div> <br />';
continua en la respuesta porque no me deja poner todo el codigo junto