Bonjour à tous, j'ai effectué une requête de jointure un peu complexe et j'aimerais afficher les données d'une façon particulière :
Voici le résultat de ma requête :
$tabGroupement = array();
while($dataa = mysql_fetch_assoc($reqa)){
$tabGroupement[$dataa['id_adh']][] = $dataa;
}
et le résultat de la commande
echo '';
print_r($tabGroupement);
echo '
';
me donne
Array
(
[4] => Array
(
[0] => Array
(
[id_adh] => 4
[id_vil] => 24
[id_log] => 4
[description] => Près de la gare et de la mer.
[type] => 1
[continent] => Afrique
[pays] => Senegal
[ville] => Vendée
[date_deb] => 2010-05-07
[date_fin] => 2010-05-29
[autre] =>
[up_nom] => 1gd.jpeg
[id_pay] => 67
[id_con] => 7
[pays_fr] => France
[cont_fr] => Europe
)
[1] => Array
(
[id_adh] => 4
[id_vil] => 24
[id_log] => 4
[description] => Près de la gare et de la mer.
[type] => 1
[continent] => Asie
[pays] => Chine
[ville] => Vendée
[date_deb] => 2009-05-31
[date_fin] => 2009-08-30
[autre] => OK
[up_nom] => 1gd.jpeg
[id_pay] => 67
[id_con] => 7
[pays_fr] => France
[cont_fr] => Europe
)
[2] => Array
(
[id_adh] => 4
[id_vil] => 24
[id_log] => 4
[description] => Près de la gare et de la mer.
[type] => 1
[continent] => Amerique du nord
[pays] => Floride
[ville] => Vendée
[date_deb] => 2010-05-22
[date_fin] => 2010-05-31
[autre] => OK
[up_nom] => 1gd.jpeg
[id_pay] => 67
[id_con] => 7
[pays_fr] => France
[cont_fr] => Europe
)
[3] => Array
(
[id_adh] => 4
[id_vil] => 24
[id_log] => 4
[description] => Près de la gare et de la mer.
[type] => 1
[continent] => Europe
[pays] => France
[ville] => Vendée
[date_deb] => 2010-04-22
[date_fin] => 2010-04-30
[autre] => OK
[up_nom] => 1gd.jpeg
[id_pay] => 67
[id_con] => 7
[pays_fr] => France
[cont_fr] => Europe
)
[4] => Array
(
[id_adh] => 4
[id_vil] => 24
[id_log] => 4
[description] => Près de la gare et de la mer.
[type] => 1
[continent] => Afrique
[pays] => Senegal
[ville] => Vendée
[date_deb] => 2010-05-07
[date_fin] => 2010-05-29
[autre] =>
[up_nom] => 1gd.jpeg
[id_pay] => 67
[id_con] => 7
[pays_fr] => France
[cont_fr] => Europe
)
[5] => Array
(
[id_adh] => 4
[id_vil] => 24
[id_log] => 4
[description] => Près de la gare et de la mer.
[type] => 1
[continent] => Asie
[pays] => Chine
[ville] => Vendée
[date_deb] => 2009-05-31
[date_fin] => 2009-08-30
[autre] => OK
[up_nom] => 1gd.jpeg
[id_pay] => 67
[id_con] => 7
[pays_fr] => France
[cont_fr] => Europe
)
[6] => Array
(
[id_adh] => 4
[id_vil] => 24
[id_log] => 4
[description] => Près de la gare et de la mer.
[type] => 1
[continent] => Amerique du nord
[pays] => Floride
[ville] => Vendée
[date_deb] => 2010-05-22
[date_fin] => 2010-05-31
[autre] => OK
[up_nom] => 1gd.jpeg
[id_pay] => 67
[id_con] => 7
[pays_fr] => France
[cont_fr] => Europe
)
[7] => Array
(
[id_adh] => 4
[id_vil] => 24
[id_log] => 4
[description] => Près de la gare et de la mer.
[type] => 1
[continent] => Europe
[pays] => France
[ville] => Vendée
[date_deb] => 2010-04-22
[date_fin] => 2010-04-30
[autre] => OK
[up_nom] => 1gd.jpeg
[id_pay] => 67
[id_con] => 7
[pays_fr] => France
[cont_fr] => Europe
)
[8] => Array
(
[id_adh] => 4
[id_vil] => 24
[id_log] => 4
[description] => Près de la gare et de la mer.
[type] => 1
[continent] => Afrique
[pays] => Senegal
[ville] => Vendée
[date_deb] => 2010-05-07
[date_fin] => 2010-05-29
[autre] =>
[up_nom] => 1gd.jpeg
[id_pay] => 67
[id_con] => 7
[pays_fr] => France
[cont_fr] => Europe
)
[9] => Array
(
[id_adh] => 4
[id_vil] => 24
[id_log] => 4
[description] => Près de la gare et de la mer.
[type] => 1
[continent] => Asie
[pays] => Chine
[ville] => Vendée
[date_deb] => 2009-05-31
[date_fin] => 2009-08-30
[autre] => OK
[up_nom] => 1gd.jpeg
[id_pay] => 67
[id_con] => 7
[pays_fr] => France
[cont_fr] => Europe
)
[10] => Array
(
[id_adh] => 4
[id_vil] => 24
[id_log] => 4
[description] => Près de la gare et de la mer.
[type] => 1
[continent] => Amerique du nord
[pays] => Floride
[ville] => Vendée
[date_deb] => 2010-05-22
[date_fin] => 2010-05-31
[autre] => OK
[up_nom] => 1gd.jpeg
[id_pay] => 67
[id_con] => 7
[pays_fr] => France
[cont_fr] => Europe
)
[11] => Array
(
[id_adh] => 4
[id_vil] => 24
[id_log] => 4
[description] => Près de la gare et de la mer.
[type] => 1
[continent] => Europe
[pays] => France
[ville] => Vendée
[date_deb] => 2010-04-22
[date_fin] => 2010-04-30
[autre] => OK
[up_nom] => 1gd.jpeg
[id_pay] => 67
[id_con] => 7
[pays_fr] => France
[cont_fr] => Europe
)
[12] => Array
(
[id_adh] => 4
[id_vil] => 24
[id_log] => 4
[description] => Près de la gare et de la mer.
[type] => 1
[continent] => Afrique
[pays] => Senegal
[ville] => Vendée
[date_deb] => 2010-05-07
[date_fin] => 2010-05-29
[autre] =>
[up_nom] => 1gd.jpeg
[id_pay] => 67
[id_con] => 7
[pays_fr] => France
[cont_fr] => Europe
)
[13] => Array
(
[id_adh] => 4
[id_vil] => 24
[id_log] => 4
[description] => Près de la gare et de la mer.
[type] => 1
[continent] => Asie
[pays] => Chine
[ville] => Vendée
[date_deb] => 2009-05-31
[date_fin] => 2009-08-30
[autre] => OK
[up_nom] => 1gd.jpeg
[id_pay] => 67
[id_con] => 7
[pays_fr] => France
[cont_fr] => Europe
)
[14] => Array
(
[id_adh] => 4
[id_vil] => 24
[id_log] => 4
[description] => Près de la gare et de la mer.
[type] => 1
[continent] => Amerique du nord
[pays] => Floride
[ville] => Vendée
[date_deb] => 2010-05-22
[date_fin] => 2010-05-31
[autre] => OK
[up_nom] => 1gd.jpeg
[id_pay] => 67
[id_con] => 7
[pays_fr] => France
[cont_fr] => Europe
)
[15] => Array
(
[id_adh] => 4
[id_vil] => 24
[id_log] => 4
[description] => Près de la gare et de la mer.
[type] => 1
[continent] => Europe
[pays] => France
[ville] => Vendée
[date_deb] => 2010-04-22
[date_fin] => 2010-04-30
[autre] => OK
[up_nom] => 1gd.jpeg
[id_pay] => 67
[id_con] => 7
[pays_fr] => France
[cont_fr] => Europe
)
[16] => Array
(
[id_adh] => 4
[id_vil] => 24
[id_log] => 4
[description] => Près de la gare et de la mer.
[type] => 1
[continent] => Afrique
[pays] => Senegal
[ville] => Vendée
[date_deb] => 2010-05-07
[date_fin] => 2010-05-29
[autre] =>
[up_nom] => 3gd.jpeg
[id_pay] => 67
[id_con] => 7
[pays_fr] => France
[cont_fr] => Europe
)
[17] => Array
(
[id_adh] => 4
[id_vil] => 24
[id_log] => 4
[description] => Près de la gare et de la mer.
[type] => 1
[continent] => Asie
[pays] => Chine
[ville] => Vendée
[date_deb] => 2009-05-31
[date_fin] => 2009-08-30
[autre] => OK
[up_nom] => 3gd.jpeg
[id_pay] => 67
[id_con] => 7
[pays_fr] => France
[cont_fr] => Europe
)
[18] => Array
(
[id_adh] => 4
[id_vil] => 24
[id_log] => 4
[description] => Près de la gare et de la mer.
[type] => 1
[continent] => Amerique du nord
[pays] => Floride
[ville] => Vendée
[date_deb] => 2010-05-22
[date_fin] => 2010-05-31
[autre] => OK
[up_nom] => 3gd.jpeg
[id_pay] => 67
[id_con] => 7
[pays_fr] => France
[cont_fr] => Europe
)
[19] => Array
(
[id_adh] => 4
[id_vil] => 24
[id_log] => 4
[description] => Près de la gare et de la mer.
[type] => 1
[continent] => Europe
[pays] => France
[ville] => Vendée
[date_deb] => 2010-04-22
[date_fin] => 2010-04-30
[autre] => OK
[up_nom] => 3gd.jpeg
[id_pay] => 67
[id_con] => 7
[pays_fr] => France
[cont_fr] => Europe
)
)
)
et à partir de ça j'aimerais avoir l'affichage suivant
pour un adhérent donné :
son identifiant(id_adh)
sa localité (cont_fr, pays_fr et ville)
toutes les photos le concernant (up_nom) ==>(il y en a plusieurs par identifiant)
toutes les destinations le concernant (continent, pays, date_deb, date_fin) ==> (il y en a plusieurs par identifiant)
merci d'avance pour votre aide.
Afficher la suite