1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
| if($Produit == "PMA_NF2"){
$req_produit = "SELECT nom_societe, nom_HCEE, N_Admission_Marque, Date_Admission, Date_De_MAJ_FT, Annee_Essai, Designation_1, Nature, Duree_De_Vie FROM societe, `produit_NF` WHERE `Nom_Produit` ='PMA_NF2' AND `Num_Etat`='1' AND numsociete = Num_Societe ORDER BY Tableau ASC, nom_societe ASC, N_Admission_Marque_NF ASC";
$result_produit = execute_mysql($req_produit, $dbhost, $dbuser, $dbpwd, $dbname);
while ($affiche_pma = mysql_fetch_array($result_produit)){
$Date_Admission = $affiche_pma['Date_Admission'];
$Date_Admission = substr($Date_Admission, 0, -5);
$Date_De_MAJ_FT = $affiche_pma['Date_De_MAJ_FT'];
$Date_De_MAJ_FT = substr($Date_De_MAJ_FT, 0, -5);
$req_site_prod = "SELECT Nom_Site_Production
FROM site_prod
WHERE num_admission = '".$affiche_pma['N_Admission_Marque']."'";
$result_site_prod = execute_mysql( $req_site_prod, $dbhost, $dbuser, $dbpwd, $dbname );
echo "<tr><td>".$Date_Admission."</td>
<td>".$Date_De_MAJ_FT."</td>
<td>".$affiche_pma['N_Admission_Marque']."</td>
<td>".$affiche_pma['Designation_1']." </td>
<td>".$affiche_pma['nom_HCEE']." </td>
<td>".$affiche_pma['Nature']."</td>
<td>".$affiche_pma['nom_societe']."</td>
<td>";
while ($site_prod = mysql_fetch_row($result_site_prod)){
echo $site_prod[0];
}
echo "</td>
<td>".$affiche_pma['Duree_De_Vie']."</td></tr>";} |
Partager