Le squadre

[source]
<?php
require_once ‘fanta/utentej.php’;
if($usr_id == 0){
header(‘Location: https://vibrant-bhaskara.185-216-75-167.plesk.page/index.php?option=com_content&view=article&id=81’);
}
require_once ‘fanta/database.php’;

$sql = “SELECT
rosa.nome_squadra,
gdalm_users.name
FROM gdalm_users
INNER JOIN rosa ON gdalm_users.id = rosa.id_user
GROUP BY rosa.nome_squadra
ORDER BY rosa.nome_squadra”;

$risultato = mysql_query($sql);

if (!$risultato):
header(‘Location: https://vibrant-bhaskara.185-216-75-167.plesk.page/index.php?option=com_content&view=article&id=87’);
exit;
endif;

if (mysql_num_rows($risultato) == 0):
header(‘Location: https://vibrant-bhaskara.185-216-75-167.plesk.page/index.php?option=com_content&view=article&id=87’);
exit;
endif;
$i = 0;
$miarosa = array();
while ($riga = mysql_fetch_assoc($risultato)):
//echo $i;
$miarosa[$i]= array(

“nome_squadra” => $riga[“nome_squadra”],
“nome” => $riga[“name”]);
//echo $riga[“rosa.nome_squadra”];
$i= $i+1;

endwhile;
//print_r($miarosa);
//echo $usr_id;
?>
<table style=”width: 100%”>
<tr>
<td colspan=”5″ style=”text-align: center”> <h3> Lista delle squadre inserite </h3></td>
</tr>
<tr>
<td style=”font-weight: bold”>Utente</td>
<td style=”font-weight: bold”>Squadra</td>
</tr>
<?php
for ($e = 0, $n = count($miarosa) ; $e < $n ; $e++)
{
echo ‘<tr>’;
echo ‘<td>’, $miarosa[$e][“nome”], ‘</td>’;
echo ‘<td>’, $miarosa[$e][“nome_squadra”], ‘</td>’;
echo ‘</tr>’;
}
// chiusura della connessione
$col = null;
?>

</table>
[/source]