 |
 |
|
riga();
(livello_modulo($DIRITTI) == "Admin") ? $query_admin = "" : $query_admin = "
AND
wf_iscritto.attivo = 1
";
$query = " SELECT
wf_iscritto.id,
wf_iscritto.attivo,
wf_iscritto.cognome,
wf_iscritto.nome,
wf_cinture.cintura,
wf_palestra.palestra,
TIMESTAMPDIFF(DAY, wf_iscritto.certificato, NOW()) AS giorni,
DATE_FORMAT(wf_iscritto.nascita_data, '%d.%m.%Y') AS nascita_data,
DATE_FORMAT(wf_iscritto.certificato, '%d.%m.%Y') AS certificato
FROM
wf_iscritto
JOIN
wf_cinture
ON
wf_iscritto.id_cintura = wf_cinture.id
JOIN
wf_palestra
ON
wf_iscritto.id_palestra = wf_palestra.id
JOIN
wf_utenti
ON
wf_palestra.id = wf_utenti.id_palestra
WHERE
wf_utenti.id_utenti = ".$UTENTE['id']."
AND
wf_utenti.attivo = 1
$query_admin
GROUP BY
id
ORDER BY
attivo desc,
$ordine
";
$res = mysql_query( $query, $DB_ID );
$tabella->intestazione (array("", "", "", "Cognome", "", "Nome", "", "Cintura", "", "Categoria", "", "Palestra", "", "Scad. Cert.", ""));
$tabella->riga();
while ($dato = mysql_fetch_array ( $res )) {
$colore = "black";
if ($dato['giorni'] > -30) $colore = "orange";
if ($dato['giorni'] > 0 || is_null ($dato['giorni'])) $colore = "red";
?>
 |
 |
 |
|
|
|
|
|
|
|
|
|
|
|
|
|
close();
?>