Pb php requête base de données [Résolu] - Programmation
TomsGuide.com : 700 000 inscrits répondent à toutes vos questions high-tech et informatique.
Pour obtenir de l'aide, inscrivez-vous gratuitement !
 

Ajouter une réponse



 Mot :   Pseudo :  
 
Bas de page
Auteur
 Sujet : Pb php requête base de données [Résolu]
 
Bruenor911
I'm Blond
Profil : IDNaute
Plus d'informations
n°125440
09-04-2008 à 08:54:50

Bonjour à tous.

J'ai une erreur, a l'affichage ça donne ça :

SELECT * FROM poste whereCoef between 0 and 1000 order by Total desc

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\Program Files\EasyPHP 2.0b1\www\Site_HAY\tableau.php on line 182

mais je comprend pas à quoi cela signifie.

Voici le bout de code auquel sa correspond :

Code :
  1. // requête SQL qui compte le nombre total d'enregistrement dans la table et qui récupère tous les enregistrements
  2. $select = 'SELECT * FROM poste order by Total desc';
  3. echo $select;
  4. $result = mysql_query($select);
  5. echo $result;
  6. $total = mysql_num_rows($result); // ligne 182
  7. echo $total;



Merci


Message édité par Bruenor911 le 10-04-2008 à 09:04:06
Liens spon sorisés

Inscrivez-vous ou connectez-vous pour masquer ceci.

mpoo
quand on sait pas on ferme sa bouche
Profil : IDNaute
Plus d'informations
n°125449
09-04-2008 à 13:35:11

il est en ligne ton site? sinon c'est normal...

coca25
Profil : IDNaute
Plus d'informations
n°125450
09-04-2008 à 13:41:14

le bout de code ne correspond pas à l'erreur
et l'erreur porte sur le "whereCoef" attaché, il faut un espace


---------------
Ne pas oublier le [resolu] pour finir le sujet.
Penser à voir les tutos, ca peut aider!
Bruenor911
I'm Blond
Profil : IDNaute
Plus d'informations
n°125457
09-04-2008 à 14:36:00

Mon site (en fait c'est une petite appli avec interface web), est en local pour l'instant.

Je fais comment pour séparé le "whereCoef" vu que ce n'est que l'affichage de ma variable select ?

Je peux mettre le code complet si vous le souhaitez.

Personnelement je suis un débutant total en php, je ne fait que poursuivre le developpement de cette mini appli.

Message cité 1 fois
lucoz
Et voila!
Profil : IDNaute
Plus d'informations
n°125461
09-04-2008 à 16:07:37

Bruenor911 a écrit :


Je fais comment pour séparé le "whereCoef" vu que ce n'est que l'affichage de ma variable select ?



Tu mets un espace entre "where" et "Coef" ta requête devrait être:

SELECT * FROM poste where Coef between 0 and 1000 order by Total desc


---------------
Emplacement à louer pour une signature.
Bruenor911
I'm Blond
Profil : IDNaute
Plus d'informations
n°125464
09-04-2008 à 16:30:04

Re

ça change rien,

Je met mon code en entier pour ce fichier des fois que ça aide :

Code :
  1. <?php
  2. // inclusion du logo
  3. include ("logo.php" );
  5. //inclusion de l'en-tête de page
  6. // By me
  7. //if (!array_key_exists('print',$_GET)) $_GET['print']=0;
  8. if (!$_GET['print']) include ("_top.php" );
  10. //inclusion du fichier contenant les différentes fonctions
  11. include ("fonctions.php" );
  12. ?>
  13. <!--Page de répartition des postes -->
  15. <h2 align = "center">Répartition des postes</h2>
  16. <!--Formulaire de tri -->
  17. <?php
  18.     // By me
  19.     //if (!array_key_exists('print',$_GET)) $_GET['print']=0;
  20.     if (!$_GET['print'])
  21. {
  22. ?>
  23. <form method="post" name="tri">
  24.   <div align="center"><strong><em>Sélectionnez vos critères de tri :</em></strong></div>
  25.   <table border="1" align = "center">
  26.     <tr>
  27.       <td colspan="4" align="center" bordercolor="#FFFFFF">
  28.               <?php $listeClassif=array("Tous"=>"Tous","Non Cadre"=>"Non Cadre","Cadre"=>"Cadre" );
  29.                 echo 'Classification : <select name="triClassif" onchange="document.tri.submit()">';
  30.                 foreach ($listeClassif as $key=>$value)
  31.                 {
  32.                     $selected = ($_POST['triClassif'] == $key)?'selected':'';
  33.                     echo '<option value="'.$key.'" '.$selected.'>'.$value.'</option>';
  34.                 }
  35.                 echo '</select>';
  37.                 $listeEtat=array("Tous"=>"Tous","Actif"=>"Actif","Non Actif"=>"Non Actif" );
  38.                 echo ' Etat : <select name="triEtat">';
  39.                 foreach ($listeEtat as $key=>$value)
  40.                 {
  41.                     $selected = ($_POST['triEtat'] == $key)?'selected':'';
  42.                     echo '<option value="'.$key.'" '.$selected.'>'.$value.'</option>';
  43.                 }
  44.                 echo '</select>';
  46.                 $listeStat=array("Tous"=>"Tous","Simulé"=>"Simulé","Validé"=>"Validé" );
  47.                 echo ' Statut : <select name="triStat">';
  48.                 foreach ($listeStat as $key=>$value)
  49.                 {
  50.                     $selected = ($_POST['triStat'] == $key)?'selected':'';
  51.                     echo '<option value="'.$key.'" '.$selected.'>'.$value.'</option>';
  52.                 }
  53.                 echo '</select>';
  54.             ?>
  55.       </td>
  56.     </tr>
  57.     <tr>
  58.       <td colspan="6" align="center" bordercolor="#FFFFFF">
  59.           Coefficient entre :
  60.         <input name="triCoefMin" type="text" size=1 maxlength="3"
  61.                     value="<?php if (isset($_POST['triClassif'])) echo $_POST['triCoefMin'];?>">
  62.         et :
  63.         <input name="triCoefMax" type="text" size=1 maxlength="3"
  64.                     value="<?php if (isset($_POST['triClassif'])) echo $_POST['triCoefMax'];?>">
  65.         Point HAY entre :
  66.         <input name="triHAYMin" type="text" size=1 maxlength="3"
  67.                     value="<?php if (isset($_POST['triClassif'])) echo $_POST['triHAYMin'];?>">
  68.         et :
  69.         <input name="triHAYMax" type="text" size=1 maxlength="3"
  70.                     value="<?php if (isset($_POST['triClassif'])) echo $_POST['triHAYMax'];?>">
  71.         <?php
  72.                 if (isset($_POST['triClassif']) && $_POST['triClassif'] == 'Cadre')
  73.                 {
  74.                     $listeClasse=array("A"=>"A","B"=>"B","C"=>"C","D"=>"D","E"=>"E","F"=>"F","G"=>"G" );
  75.                     echo 'Classe : <select name="triClassMin">';
  76.                     foreach ($listeClasse as $key=>$value)
  77.                     {
  78.                         $selected = ($_POST['triClassMin'] == $key)?'selected':'';
  79.                         echo '<option value="'.$key.'" '.$selected.'>'.$value.'</option>';
  80.                     }
  81.                     echo '</select>';
  82.                     $listeClasseR=array("G"=>"G","F"=>"F","E"=>"E","D"=>"D","C"=>"C","B"=>"B","A"=>"A" );
  83.                     echo 'à : <select name="triClassMax">';
  84.                     foreach ($listeClasseR as $key=>$value)
  85.                     {
  86.                         $selected = ($_POST['triClassMax'] == $key)?'selected':'';
  87.                         echo '<option value="'.$key.'" '.$selected.'>'.$value.'</option>';
  88.                     }
  89.                     echo '</select>';
  90.                 }
  91.                 else if (isset($_POST['triClassif']) && $_POST['triClassif'] == 'Non Cadre')
  92.                 {
  93.                     $listeGroupe=array("I"=>"I","II"=>"II","III"=>"III","IV"=>"IV","V"=>"V","VI"=>"VI","VII"=>"VII" );
  94.                     echo 'Groupe : <select name="triClassMin">';
  95.                     foreach ($listeGroupe as $key=>$value)
  96.                     {
  97.                         $selected = ($_POST['triClassMin'] == $key)?'selected':'';
  98.                         echo '<option value="'.$key.'" '.$selected.'>'.$value.'</option>';
  99.                     }
  100.                     echo '</select>';
  101.                     $listeGroupeR=array("VII"=>"VII","VI"=>"VI","V"=>"V","IV"=>"IV","III"=>"III","II"=>"II","I" =>"I" );
  102.                     echo 'à : <select name="triClassMax">';
  103.                     foreach ($listeGroupeR as $key=>$value)
  104.                     {
  105.                         $selected = ($_POST['triClassMax'] == $key)?'selected':'';
  106.                         echo '<option value="'.$key.'" '.$selected.'>'.$value.'</option>';
  107.                     }
  108.                     echo '</select>';
  109.                 }
  110.         ?>
  111.       </td>
  112.     </tr>
  113.     <tr align="center">
  114.       <td align="center" bordercolor="#FFFFFF"><input type="submit" name="ok" value="Ok"></td>
  115.     </tr>
  116.   </table>
  117. </form>
  118. <?php
  119. }
  120. if (isset($_POST["ok"]))
  121. {
  122.     $select = 'SELECT * FROM poste where';
  123.     if ($_POST['triCoefMin'] == '' && $_POST['triCoefMax'] == '')
  124.         $select .= 'Coef between 0 and 1000';
  125.     else if ($_POST['triCoefMin'] <> '' && !is_numeric($_POST['triCoefMin']))
  126.         {alert("Le coefficient minimum doit être un chiffre!" );
  127.         retour();}
  128.     else if ($_POST['triCoefMax'] <> '' && !is_numeric($_POST['triCoefMax']))
  129.         {alert("Le coefficient maximum doit être un chiffre!" );
  130.         retour();}
  131.     else if ($_POST['triCoefMin'] <> '' && $_POST['triCoefMax'] <> '' && $_POST['triCoefMin'] > $_POST['triCoefMax'])
  132.         {alert("Le coefficient minimum doit être inférieur au coefficient maximum!" );
  133.         retour();}
  134.     else if ($_POST['triCoefMin'] <> '' && $_POST['triCoefMax'] == '')
  135.         $select .= ' Coef="'.$_POST['triCoefMin'].'"';
  136.     else if ($_POST['triCoefMax'] <> '' && $_POST['triCoefMin'] == '')
  137.         $select .= ' Coef="'.$_POST['triCoefMax'].'"';
  138.     else if ($_POST['triCoefMin'] <> '' && $_POST['triCoefMax'] <> '')
  139.         $select .= ' Coef between "'.$_POST['triCoefMin'].'" and "'.$_POST['triCoefMax'].'"';
  141.     if ($_POST['triClassif'] == 'Cadre')
  142.         $select .= ' and Classification="Cadre"';
  143.     if ($_POST['triClassif'] == 'Non Cadre')
  144.         $select .= ' and Classification="Non Cadre"';
  146.     if ($_POST['triEtat'] == 'Actif')
  147.         $select .= ' and Etat="Actif"';
  148.     if ($_POST['triEtat'] == 'Non Actif')
  149.         $select .= ' and Etat="Non Actif"';
  151.     if ($_POST['triStat'] == 'Simulé')
  152.         $select .= ' and Statut="Simulé"';
  153.     if ($_POST['triStat'] == 'Validé')
  154.         $select .= ' and Statut="Validé"';
  156.     if ($_POST['triHayMin'] <> '' && !is_numeric($_POST['triHayMin']))
  157.         {alert("Le total HAY minimum doit être un chiffre!" );
  158.         retour();}
  159.     else if ($_POST['triHayMax'] <> '' && !is_numeric($_POST['triHayMax']))
  160.         {alert("Le total HAY maximum doit être un chiffre!" );
  161.         retour();}
  162.     else if ($_POST['triHayMin'] <> '' && $_POST['triHayMax'] <> '' && $_POST['triHayMin'] > $_POST['triHayMax'])
  163.         {alert("Le total HAY minimum doit être inférieur au total HAY maximum!" );
  164.         retour();}
  165.     else if ($_POST['triHAYMin'] <> '' && $_POST['triHAYMax'] == '')
  166.         $select .= ' and Total='.$_POST['triHAYMin'];
  167.     else if ($_POST['triHAYMax'] <> '' && $_POST['triHAYMin'] == '')
  168.         $select .= ' and Total='.$_POST['triHAYMax'];
  169.     else if ($_POST['triHAYMin'] <> '' && $_POST['triHAYMax'] <> '')
  170.         $select .= ' and Total between '.$_POST['triHAYMin'].' and '.$_POST['triHAYMax'];
  172.     if (isset($_POST['triClassMin']) || $_POST['triClassMax'])
  173.         $select .= ' and Classement between "'.$_POST['triClassMin'].'" and "'.$_POST['triClassMax'].'"';
  175.     $select .= ' order by Total desc';
  176. }
  177. else
  178.     // requête SQL qui compte le nombre total d'enregistrement dans la table et qui récupère tous les enregistrements    
  179.     $select = 'SELECT * FROM poste order by Total desc';
  180.     echo $select;
  181.     $result = mysql_query($select, $link);
  182.     echo $result;
  183.     $total = mysql_num_rows($result);
  184.     echo $total;
  186. if($total)
  187. {
  188.     while ($row = mysql_fetch_array($result))
  189.       {
  190.            if ($row['Direction'] == "DC" && ($row['Classement'] == "VII" || $row['Classement'] == "G" ))
  191.              $txtDCG .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  193.         if ($row['Direction'] == "DG" && ($row['Classement'] == "VII" || $row['Classement'] == "G" ))
  194.             $txtDGG .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  196.         if ($row['Direction'] == "DLM" && ($row['Classement'] == "VII" || $row['Classement'] == "G" ))
  197.             $txtDLMG .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  199.         if ($row['Direction'] == "DO" && ($row['Classement'] == "VII" || $row['Classement'] == "G" ))
  200.             $txtDOG .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  202.         if ($row['Direction'] == "DT" && ($row['Classement'] == "VII" || $row['Classement'] == "G" ))
  203.             $txtDTG .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  205.         if ($row['Direction'] == "INFO" && ($row['Classement'] == "VII" || $row['Classement'] == "G" ))
  206.             $txtINFOG .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  208.         if ($row['Direction'] == "MKG" && ($row['Classement'] == "VII" || $row['Classement'] == "G" ))
  209.             $txtMKGG .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  211.         if ($row['Direction'] == "RH" && ($row['Classement'] == "VII" || $row['Classement'] == "G" ))
  212.             $txtRHG .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>"; 
  214.         if ($row['Direction'] == "SG" && ($row['Classement'] == "VII" || $row['Classement'] == "G" ))
  215.             $txtSGG .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  217.         /***********************************************************************************************/
  219.         if ($row['Direction'] == "DC" && ($row['Classement'] == "VI" || $row['Classement'] == "F" ))
  220.              $txtDCF .= $row['NumDP']."&nbsp;".$row['Intitule']." - ".$row['Total']." - ".$row['Coef']."<BR>";
  222.         if ($row['Direction'] == "DG" && ($row['Classement'] == "VI" || $row['Classement'] == "F" ))
  223.             $txtDGF .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  225.         if ($row['Direction'] == "DLM" && ($row['Classement'] == "VI" || $row['Classement'] == "F" ))
  226.             $txtDLMF .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  228.         if ($row['Direction'] == "DO" && ($row['Classement'] == "VI" || $row['Classement'] == "F" ))
  229.             $txtDOF .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  231.         if ($row['Direction'] == "DT" && ($row['Classement'] == "VI" || $row['Classement'] == "F" ))
  232.             $txtDTF .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  234.         if ($row['Direction'] == "INFO" && ($row['Classement'] == "VI" || $row['Classement'] == "F" ))
  235.             $txtINFOF .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  237.         if ($row['Direction'] == "MKG" && ($row['Classement'] == "VI" || $row['Classement'] == "F" ))
  238.             $txtMKGF .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  240.         if ($row['Direction'] == "RH" && ($row['Classement'] == "VI" || $row['Classement'] == "F" ))
  241.             $txtRHF .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>"; 
  243.         if ($row['Direction'] == "SG" && ($row['Classement'] == "VI" || $row['Classement'] == "F" ))
  244.             $txtSGF .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  246.         /***********************************************************************************************/
  248.         if ($row['Direction'] == "DC" && ($row['Classement'] == "V" || $row['Classement'] == "E" ))
  250.              $txtDCE .= $row['NumDP']."&nbsp;".$row['Intitule']." - ".$row['Total']." - ".$row['Coef']."<BR>";
  252.         if ($row['Direction'] == "DG" && ($row['Classement'] == "V" || $row['Classement'] == "E" ))
  253.             $txtDGE .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  255.         if ($row['Direction'] == "DLM" && ($row['Classement'] == "V" || $row['Classement'] == "E" ))
  256.             $txtDLME .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  258.         if ($row['Direction'] == "DO" && ($row['Classement'] == "V" || $row['Classement'] == "E" ))
  259.             $txtDOE .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  261.         if ($row['Direction'] == "DT" && ($row['Classement'] == "V" || $row['Classement'] == "E" ))
  262.             $txtDTE .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  264.         if ($row['Direction'] == "INFO" && ($row['Classement'] == "V" || $row['Classement'] == "E" ))
  265.             $txtINFOE .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  267.         if ($row['Direction'] == "MKG" && ($row['Classement'] == "V" || $row['Classement'] == "E" ))
  268.             $txtMKGE .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  270.         if ($row['Direction'] == "RH" && ($row['Classement'] == "V" || $row['Classement'] == "E" ))
  271.             $txtRHE .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  273.         if ($row['Direction'] == "SG" && ($row['Classement'] == "V" || $row['Classement'] == "E" ))
  274.             $txtSGE .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  276.         /***********************************************************************************************/
  278.         if ($row['Direction'] == "DC" && ($row['Classement'] == "IV" || $row['Classement'] == "D" ))
  279.              $txtDCD .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  281.         if ($row['Direction'] == "DG" && ($row['Classement'] == "IV" || $row['Classement'] == "D" ))
  282.             $txtDGD .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  284.         if ($row['Direction'] == "DLM" && ($row['Classement'] == "IV" || $row['Classement'] == "D" ))
  285.             $txtDLMD .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  287.         if ($row['Direction'] == "DO" && ($row['Classement'] == "IV" || $row['Classement'] == "D" ))
  288.             $txtDOD .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  290.         if ($row['Direction'] == "DT" && ($row['Classement'] == "IV" || $row['Classement'] == "D" ))
  291.             $txtDTD .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  293.         if ($row['Direction'] == "INFO" && ($row['Classement'] == "IV" || $row['Classement'] == "D" ))
  294.             $txtINFOD .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  296.         if ($row['Direction'] == "MKG" && ($row['Classement'] == "IV" || $row['Classement'] == "D" ))
  297.             $txtMKGD .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  299.         if ($row['Direction'] == "RH" && ($row['Classement'] == "IV" || $row['Classement'] == "D" ))
  300.             $txtRHD .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  302.         if ($row['Direction'] == "SG" && ($row['Classement'] == "IV" || $row['Classement'] == "D" ))
  303.             $txtSGD .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  305.         /***********************************************************************************************/
  307.         if ($row['Direction'] == "DC" && ($row['Classement'] == "III" || $row['Classement'] == "C" ))
  308.              $txtDCC .= $row['NumDP']."&nbsp;".$row['Intitule']." - ".$row['Total']." - ".$row['Coef']."<BR>";
  311.         if ($row['Direction'] == "DG" && ($row['Classement'] == "III" || $row['Classement'] == "C" ))
  312.             $txtDGC .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  314.         if ($row['Direction'] == "DLM" && ($row['Classement'] == "III" || $row['Classement'] == "C" ))
  315.             $txtDLMC .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  317.         if ($row['Direction'] == "DO" && ($row['Classement'] == "III" || $row['Classement'] == "C" ))
  318.             $txtDOC .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  320.         if ($row['Direction'] == "DT" && ($row['Classement'] == "III" || $row['Classement'] == "C" ))
  321.             $txtDTC .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  323.         if ($row['Direction'] == "INFO" && ($row['Classement'] == "III" || $row['Classement'] == "C" ))
  324.             $txtINFOC .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  326.         if ($row['Direction'] == "MKG" && ($row['Classement'] == "III" || $row['Classement'] == "C" ))
  327.             $txtMKGC .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  329.         if ($row['Direction'] == "RH" && ($row['Classement'] == "III" || $row['Classement'] == "C" ))
  330.             $txtRHC .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  332.         if ($row['Direction'] == "SG" && ($row['Classement'] == "III" || $row['Classement'] == "C" ))
  333.             $txtSGC .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  335.         /***********************************************************************************************/
  337.         if ($row['Direction'] == "DC" && ($row['Classement'] == "II" || $row['Classement'] == "B" ))
  338.              $txtDCB .= $row['NumDP']."&nbsp;".$row['Intitule']." - ".$row['Total']." - ".$row['Coef']."<BR>";
  340.         if ($row['Direction'] == "DG" && ($row['Classement'] == "II" || $row['Classement'] == "B" ))
  341.             $txtDGB .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  343.         if ($row['Direction'] == "DLM" && ($row['Classement'] == "II" || $row['Classement'] == "B" ))
  344.             $txtDLMB .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  346.         if ($row['Direction'] == "DO" && ($row['Classement'] == "II" || $row['Classement'] == "B" ))
  347.             $txtDOB .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  349.         if ($row['Direction'] == "DT" && ($row['Classement'] == "II" || $row['Classement'] == "B" ))
  350.             $txtDTB .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  352.         if ($row['Direction'] == "INFO" && ($row['Classement'] == "II" || $row['Classement'] == "B" ))
  353.             $txtINFOB .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  355.         if ($row['Direction'] == "MKG" && ($row['Classement'] == "II" || $row['Classement'] == "B" ))
  356.             $txtMKGB .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  358.         if ($row['Direction'] == "RH" && ($row['Classement'] == "II" || $row['Classement'] == "B" ))
  359.             $txtRHB .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  361.         if ($row['Direction'] == "SG" && ($row['Classement'] == "II" || $row['Classement'] == "B" ))
  362.             $txtSGB .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  364.         /***********************************************************************************************/
  366.         if ($row['Direction'] == "DC" && ($row['Classement'] == "I" || $row['Classement'] == "A" ))
  367.              $txtDCA .= $row['NumDP']."&nbsp;".$row['Intitule']." - ".$row['Total']." - ".$row['Coef']."<BR>";
  369.         if ($row['Direction'] == "DG" && ($row['Classement'] == "I" || $row['Classement'] == "A" ))
  370.             $txtDGA .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  372.         if ($row['Direction'] == "DLM" && ($row['Classement'] == "I" || $row['Classement'] == "A" ))
  373.             $txtDLMA .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  375.         if ($row['Direction'] == "DO" && ($row['Classement'] == "I" || $row['Classement'] == "A" ))
  376.             $txtDOA .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  378.         if ($row['Direction'] == "DT" && ($row['Classement'] == "I" || $row['Classement'] == "A" ))
  379.             $txtDTA .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  381.         if ($row['Direction'] == "INFO" && ($row['Classement'] == "I" || $row['Classement'] == "A" ))
  382.             $txtINFOA .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  384.         if ($row['Direction'] == "MKG" && ($row['Classement'] == "I" || $row['Classement'] == "A" ))
  385.             $txtMKGA .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  387.         if ($row['Direction'] == "RH" && ($row['Classement'] == "I" || $row['Classement'] == "A" ))
  388.             $txtRHA .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  390.         if ($row['Direction'] == "SG" && ($row['Classement'] == "I" || $row['Classement'] == "A" ))
  391.             $txtSGA .= $row['NumDP']."&nbsp;".$row['Intitule']."&nbsp;".$row['Total']."&nbsp;".$row['Coef']."<BR>";
  392.     }
  393. }
  394. ?>
  395. <form name="tableau" method="post" action="">
  396.   <table width="1000" align="center" border="1" cellspacing="0" cellpadding="1">
  397.     <caption align="center" style="border:double">
  398.     Légende :<br />
  399.     N°DP Intitulé Points Hay Coefficient
  400.     <tr>
  401.       <th scope="col">&nbsp;</th>
  402.       <th scope="col">DC</th>
  403.       <th scope="col">DG</th>
  404.       <th scope="col">DLM</th>
  405.       <th scope="col">DO</th>
  406.       <th scope="col">DT</th>
  407.       <th scope="col">INFO</th>
  408.       <th scope="col">MKG</th>
  409.       <th scope="col">RH</th>
  410.       <th scope="col">SG</th>
  411.     </tr>
  412.     <tr>
  413.       <th scope="row"><?php if (isset($_POST['triClassif']) && $_POST['triClassif'] == 'Non Cadre') echo "VII";
  414.                       else if (isset($_POST['triClassif']) && $_POST['triClassif'] == 'Cadre') echo "G";
  415.                       else echo "&nbsp;";?>
  416.       </th>
  417.       <td><?php if (isset($txtDCG)) echo $txtDCG; else echo "&nbsp;";?></td>
  418.       <td><?php if (isset($txtDGG)) echo $txtDGG; else echo "&nbsp;";?></td>
  419.       <td><?php if (isset($txtDLMG)) echo $txtDLMG; else echo "&nbsp;";?></td>
  420.       <td><?php if (isset($txtDOG)) echo $txtDOG; else echo "&nbsp;";?></td>
  421.       <td><?php if (isset($txtDTG)) echo $txtDTG; else echo "&nbsp;";?></td>
  422.       <td><?php if (isset($txtINFOG)) echo $txtINFOG; else echo "&nbsp;";?></td>
  423.       <td><?php if (isset($txtMKGG)) echo $txtMKGG; else echo "&nbsp;";?></td>
  424.       <td><?php if (isset($txtRHG)) echo $txtRHG; else echo "&nbsp;";?></td>
  425.       <td><?php if (isset($txtSGG)) echo $txtSGCG; else echo "&nbsp;";?></td>
  426.     </tr>
  427.     <tr>
  428.       <th scope="row"><?php if (isset($_POST['triClassif']) && $_POST['triClassif'] == 'Non Cadre') echo "VI";
  429.                       else if (isset($_POST['triClassif']) && $_POST['triClassif'] == 'Cadre') echo "F";
  430.                       else echo "&nbsp;";?>
  431.       </th>
  432.       <td><?php if (isset($txtDCF)) echo $txtDCF; else echo "&nbsp;";?></td>
  433.       <td><?php if (isset($txtDGF)) echo $txtDGF; else echo "&nbsp;";?></td>
  434.       <td><?php if (isset($txtDLMF)) echo $txtDLMF; else echo "&nbsp;";?></td>
  435.       <td><?php if (isset($txtDOF)) echo $txtDOF; else echo "&nbsp;";?></td>
  436.       <td><?php if (isset($txtDTF)) echo $txtDTF; else echo "&nbsp;";?></td>
  437.       <td><?php if (isset($txtINFOF)) echo $txtINFOF; else echo "&nbsp;";?></td>
  438.       <td><?php if (isset($txtMKGF)) echo $txtMKGF; else echo "&nbsp;";?></td>
  439.       <td><?php if (isset($txtRHF)) ech