require("../../init.php");
$equipment=$_GET['equipment'];
$page_appelante=$_GET['page_appelante'];
//$page_appelante = $_SERVER['PHP_SELF'];
//on crée une variable selection dans laquelle on met tous les champs sélectionnés
$matos_select= "SELECT type, reference, caracteristique, origine, localisation FROM $sql_tble_mat where reference ='$equipment'";
$requete_mat=mysql_query($matos_select)
or die ("la requete select des champs a échouée");
//on récupere les valeurs de la requete sur la table materiel
$type=mysql_result($requete_mat,"","type");
$reference=mysql_result($requete_mat,"","reference");
$caracteristique=mysql_result($requete_mat,"","caracteristique");
$origine=mysql_result($requete_mat,"","origine");
$localisation=mysql_result($requete_mat,"","localisation");
$evenement= "SELECT id, campagne, mouillage, relevage, calibration, reparation FROM $sql_tble_evmt where nom_equip = '$equipment' Order by mouillage ";
$requete_evemt=mysql_query($evenement)
or die ("la requete select des champs a échouée");
$date_maj= "SELECT date_m_a_j FROM $sql_tble_evmt where nom_equip = '$reference' Order by date_m_a_j desc ";
$requete_date=mysql_query($date_maj)
or die ("la requete $date_maj a échouée");
//on récupere les valeurs de la requete sur la table evenement
$nbre_lignes= mysql_num_rows($requete_evemt);
for($i=0;$i<$nbre_lignes;$i++)
{
$id[]=mysql_result($requete_evemt,"$i","id");
$campagne[]=mysql_result($requete_evemt,"$i","campagne");
$mouillage_us=mysql_result($requete_evemt,"$i","mouillage");
$tab_mouil = explode("-",$mouillage_us);
$annee= $tab_mouil[0];
$mois =$tab_mouil[1];
$jour = $tab_mouil[2];
$mouillage[$i]= $jour."/".$mois."/".$annee;
$relevage_us=mysql_result($requete_evemt,"$i","relevage");
$tab_relev = explode("-",$relevage_us);
$annee= $tab_relev[0];
$mois =$tab_relev[1];
$jour = $tab_relev[2];
$relevage[$i]= $jour."/".$mois."/".$annee;
$calibration[]=mysql_result($requete_evemt,"$i","calibration");
$commentaire[]=mysql_result($requete_evemt,"$i","reparation");
$date_us=mysql_result($requete_date,$i,"date_m_a_j");
$tab = explode("-",$date_us);
$annee= $tab[0];
$mois = $tab[1];
$jour = $tab[2];
$date_m_a_j[$i]= $jour."/".$mois."/".$annee;
}
// on ferme la connexion à mysql
mysql_close();
?>