#HTTP_HEADER{Content-Type:Text/html;charset=#CHARSET} #CACHE{0} '0000-00-00 00:00:00' and YEAR(b.date) = YEAR('[(#ENV{date_liste})]') and MONTH(b.date) = MONTH('[(#ENV{date_liste})]') group by b.id_abonnement"); echo "
[(#ENV{date_liste}|nom_mois)] [(#ENV{date_liste}|annee)] | "; $query_n = spip_query ( "select b.id_abonnement from spip_abonnements a, spip_auteurs_elargis_abonnements b , spip_auteurs_elargis c where a.id_abonnement = b.id_abonnement and c.id = b.id_auteur_elargi and c.statut_paiement = 'ok' and b.validite <> '0000-00-00 00:00:00' and YEAR(b.date) = YEAR('[(#ENV{date_liste})]') and MONTH(b.date) = MONTH('[(#ENV{date_liste})]') " ); $n = spip_num_rows($query_n); echo "$n | "; echo "||||||
---|---|---|---|---|---|---|---|
".$row['libelle']." | ".$row['n']." | "; echo "||||||
Prenom | Nom | adresse | code postal | Ville | pays | date | expire | "; echo "
".$row_detail['prenom']." | ".$row_detail['nom_famille']." | "; echo "".$row_detail['adresse']." | ".$row_detail['code_postal']." | ".$row_detail['ville']." | ".$row_detail['pays']." | "; echo "".jour($row_detail['date'])."/".mois($row_detail['date'])."/".annee($row_detail['date'])." | "; echo "".jour($row_detail['validite'])."/".mois($row_detail['validite'])."/".annee($row_detail['validite'])." | "; echo "
"; echo " |