";
display_lng_text("DETAIL_IND_FATHER");
echo " : $row_par[PRENOM] $row_par[LIBELLE]
";
}
$result_par = mysql_query( "select INDIVIDUS.ID_INDIVIDU as ID_IND, INDIVIDUS.PRENOM, PATRONYMES.LIBELLE from INDIVIDUS, PATRONYMES where ID_INDIVIDU='$row_ind[ID_MERE]' and PATRONYMES.ID_PATRONYME=INDIVIDUS.ID_PATRONYME");
if($row_par = mysql_fetch_array($result_par))
{
echo "
";
display_lng_text("DETAIL_IND_MOTHER");
echo " : $row_par[PRENOM] $row_par[LIBELLE]
";
}
if($row_ind[ID_PAYS_NAISSANCE]!="999999")
{
if($row_ind[ID_ZONE_NAISSANCE]!="999999")
{
if($row_ind[ID_VILLE_NAISSANCE]!="999999")
{
$result_lieu = mysql_query( "select VILLES.LIBELLE as LIB_VILLE, PAYS.LIBELLE as LIB_PAYS, ZONES.LIBELLE as LIB_ZONE from PAYS, ZONES, VILLES where PAYS.ID_PAYS='$row_ind[ID_PAYS_NAISSANCE]' and ZONES.ID_ZONE='$row_ind[ID_ZONE_NAISSANCE]' and VILLES.ID_VILLE='$row_ind[ID_VILLE_NAISSANCE]' and PAYS.ID_PAYS=ZONES.ID_PAYS and VILLES.ID_ZONE=ZONES.ID_ZONE");
if($row_lieu = mysql_fetch_array($result_lieu))
{
echo "
";
display_lng_text("DETAIL_IND_BIRTH_PLACE");
echo " : $row_lieu[LIB_PAYS] - $row_lieu[LIB_ZONE] - $row_lieu[LIB_VILLE]
";
}
}
else
{
$result_lieu = mysql_query( "select PAYS.LIBELLE as LIB_PAYS, ZONES.LIBELLE as LIB_ZONE from PAYS, ZONES where PAYS.ID_PAYS='$row_ind[ID_PAYS_NAISSANCE]' and ZONES.ID_ZONE='$row_ind[ID_ZONE_NAISSANCE]' and PAYS.ID_PAYS=ZONES.ID_PAYS");
if($row_lieu = mysql_fetch_array($result_lieu))
{
echo "
";
display_lng_text("DETAIL_IND_BIRTH_PLACE");
echo " : $row_lieu[LIB_PAYS] - $row_lieu[LIB_ZONE]
";
}
}
}
else
{
$result_lieu = mysql_query( "select PAYS.LIBELLE as LIB_PAYS from PAYS where PAYS.ID_PAYS='$row_ind[ID_PAYS_NAISSANCE]'");
if($row_lieu = mysql_fetch_array($result_lieu))
{
echo "
";
display_lng_text("DETAIL_IND_BIRTH_PLACE");
echo " : $row_lieu[LIB_PAYS]
";
}
}
}
$result = mysql_query( "select EVENEMENTS_TYPE.LIBELLE as LIBELLE_TYPE, EVENEMENTS.LIBELLE as LIBELLE_EVNT, EVENEMENTS.ID_EVENEMENT as EVNT_ID, IND_LINK from EVENEMENTS, EVENEMENTS_TYPE where ID_PERE='$INDIVIDU' and TYPE_PERE=0 and EVENEMENTS_TYPE.ID_TYPE_EVENT=EVENEMENTS.TYPE order by EVENEMENTS.ID_EVENEMENT");
while($row = mysql_fetch_array($result))
{
echo "
$row[LIBELLE_TYPE] : $row[LIBELLE_EVNT]"; if($row[IND_LINK]!=-1) { display_lng_text("DETAIL_IND_WITH"); echo " "; affiche_lien_individu($row[IND_LINK]); } info_evnt($row[EVNT_ID],1,1); } $nb_enfants=0; $result_ind = mysql_query( "select INDIVIDUS.ID_INDIVIDU as ID_IND, INDIVIDUS.PRENOM, PATRONYMES.LIBELLE from INDIVIDUS, PATRONYMES where (ID_PERE='$INDIVIDU' or ID_MERE='$INDIVIDU') and PATRONYMES.ID_PATRONYME=INDIVIDUS.ID_PATRONYME"); while($row_ind = mysql_fetch_array($result_ind)) { if($nb_enfants==0) { echo "
$row_ind[LIBELLE] $row_ind[PRENOM]
";
$nb_enfants++;
}
affiche_pied_page(true);
?>