 |
 |
|
riga();
$query = " SELECT
wf_palestra.id,
wf_palestra.attivo,
wf_palestra.palestra,
wf_palestra.sigla,
count(wf_iscritto.id_palestra) AS iscritti
FROM
wf_palestra
LEFT OUTER JOIN
wf_iscritto
ON
wf_iscritto.id_palestra = wf_palestra.id
AND
wf_iscritto.attivo = 1
GROUP BY
wf_palestra.id,
wf_palestra.attivo,
wf_palestra.palestra
ORDER BY
attivo desc,
palestra
";
$res = mysql_query( $query, $DB_ID );
$tabella->intestazione (array("", "", "", "Palestra", "", "Sigla", "", "Iscritti", ""));
$tabella->riga();
while ($dato = mysql_fetch_array ( $res )) {
?>
 |
 |
 |
|
|
|
|
|
|
|
close();
?>