Chargement des statistiques :

type: Tout

$value) { echo ' '; } ?> 0) AS hsd_nbr, (SELECT COUNT(*) FROM member A INNER JOIN member_particip B ON B.membre=A.id WHERE B.annee=:an AND A.sex=0 AND B.course=1) AS fss_nbr, (SELECT COUNT(*) FROM member A INNER JOIN member_particip B ON B.membre=A.id WHERE B.annee=:an AND A.sex=0 AND B.course=1 AND B.dossard>0) AS fsd_nbr, (SELECT COUNT(*) FROM member A INNER JOIN member_particip B ON B.membre=A.id WHERE B.annee=:an AND A.sex=1 AND B.course=2) AS hps_nbr, (SELECT COUNT(*) FROM member A INNER JOIN member_particip B ON B.membre=A.id WHERE B.annee=:an AND A.sex=1 AND B.course=2 AND B.dossard>0) AS hpd_nbr, (SELECT COUNT(*) FROM member A INNER JOIN member_particip B ON B.membre=A.id WHERE B.annee=:an AND A.sex=0 AND B.course=2) AS fps_nbr, (SELECT COUNT(*) FROM member A INNER JOIN member_particip B ON B.membre=A.id WHERE B.annee=:an AND A.sex=0 AND B.course=2 AND B.dossard>0) AS fpd_nbr; "; $arg = array('an'=>$config['smib_annee_encours']); $donnee = $db->select($req, $arg, false); ?>

'.$value.' '.$headras[1][$x].'
21Km Hommes			0) ? round(($donnee['hsd_nbr']*100)/$donnee['hss_nbr']).'%' : '/' ?>
21Km Femmes			0) ? round(($donnee['fsd_nbr']*100)/$donnee['fss_nbr']).'%' : '/' ?>
7Km Hommes			0) ? round(($donnee['hpd_nbr']*100)/$donnee['hps_nbr']).'%' : '/' ?>
7Km Femmes			0) ? round(($donnee['fpd_nbr']*100)/$donnee['fps_nbr']).'%' : '/' ?>
Total			/

$value) { echo ' '; } ?> $config['smib_annee_encours']); $donnee = $db->select($req, $arg, false); ?>

'.$value.' '.$headras[1][$x].'
Handisports
Hypertension
Diabète
Asthme

$config['smib_annee_encours']); $donnees = $db->select($req, $arg, true); foreach ($donnees as $key => $donnee) { ?>

	Pays Pays	Nombre de participants Nombre

$config['smib_annee_encours']); $donnees = $db->select($req, $arg, true); foreach ($donnees as $key => $donnee) { ?>

Wilaya Wilaya	Nombre de participants Nombre

$config['smib_annee_encours']); $donnees = $db->select($req, $arg, true); foreach ($donnees as $key => $donnee) { ?>

Commune Commune	Nombre de participants Nombre

2 ORDER BY id"; $arg = array(); $donnees = $db->select($req, $arg, true); foreach ($donnees as $key => $donnee) { $req = " SELECT COUNT(*) AS nbr FROM member_particip WHERE annee=:annee AND dossard>0 AND agent=:id "; $arg = array('id'=>$donnee['id'], 'annee'=>$config['smib_annee_encours']); $data = $db->select($req, $arg, false); ?>

Agents village Agent	Nombre de dossards dossards