inserire da remoto dati in una tabella

<?php
$query="SELECT * FROM risultati ORDER BY data DESC";
$query=mysql_query($query);

if(mysql_num_rows($query)) {?>
    <table>
    <tr>
        <td>Data</td>
        <td>Squadra di casa</td>
        <td>Punteggio casa</td>
        <td>Punteggio ospiti</td>
        <td>Squadra ospiti</td>
    </tr><?php
    for($i=0;$i<mysql_num_rows($query);$i++) {?>
        <tr>
        <td><?php echo mysql_result($query,$i,'data');?></td>
        <td><?php echo get_nome_squadra(mysql_result($query,$i,'sq1'));?></td>
        <td><?php echo mysql_result($query,$i,'p1');?></td>
        <td><?php echo get_nome_squadra(mysql_result($query,$i,'sq1'));?></td>
        <td><?php echo mysql_result($query,$i,'p2');?></td>
        </tr><?php
    }?>
    </table><?php
}

function get_nome_squadra($id) {
    $q="SELECT nome FROM squadra WHERE id='$id' LIMIT 1";
    $q=mysql_query($q);
    if(mysql_num_rows($q)) {
         return mysql_result($q,0,'nome');
    }
}?>