Tom's Guide > Forum > Programmation > Pb php requête base de données [Résolu]

Pb php requête base de données [Résolu]

Forum Programmation : Pb php requête base de données [Résolu]

TomsGuide.com : 800 000 inscrits répondent à toutes vos questions high-tech et informatique. Pour obtenir de l'aide, inscrivez-vous gratuitement !
Créer un nouveau sujet Répondre
Mot :    Pseudo :           
 
Bruenor911   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
Répondre
Liens sponsorisés
Inscrivez-vous ou connectez-vous pour masquer ceci.
mpoo   09-04-2008 à 13:35:11
- 0 +

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

Répondre à mpoo
coca25   09-04-2008 à 13:41:14
- 0 +

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!
 Répondre à coca25
Bruenor911   09-04-2008 à 14:36:00
- 0 +

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
Répondre à Bruenor911
lucoz   09-04-2008 à 16:07:37
- 0 +

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

------------------------------ angela936 a écrit :"l'homosexualité est toléré sur le forum pourquoi pas l'homophobie ?!"
 Répondre à lucoz
Bruenor911   09-04-2008 à 16:30:04
- 0 +

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)) echo $txtRHF; else echo "&nbsp;";?></td>
  440.       <td><?php if (isset($txtSGF)) echo $txtSGCF; else echo "&nbsp;";?></td>
  441.     </tr>
  442.     <tr>
  443.       <th scope="row"><?php if (isset($_POST['triClassif']) && $_POST['triClassif'] == 'Non Cadre') echo "V";
  444.                       else if (isset($_POST['triClassif']) && $_POST['triClassif'] == 'Cadre') echo "E";
  445.                       else echo "&nbsp;";?>
  446.       </th>
  447.       <td><?php if (isset($txtDCE)) echo $txtDCE; else echo "&nbsp;";?></td>
  448.       <td><?php if (isset($txtDGE)) echo $txtDGE; else echo "&nbsp;";?></td>
  449.       <td><?php if (isset($txtDLME)) echo $txtDLME; else echo "&nbsp;";?></td>
  450.       <td><?php if (isset($txtDOE)) echo $txtDOE; else echo "&nbsp;";?></td>
  451.       <td><?php if (isset($txtDTE)) echo $txtDTE; else echo "&nbsp;";?></td>
  452.       <td><?php if (isset($txtINFOE)) echo $txtINFOE; else echo "&nbsp;";?></td>
  453.       <td><?php if (isset($txtMKGE)) echo $txtMKGE; else echo "&nbsp;";?></td>
  454.       <td><?php if (isset($txtRHE)) echo $txtRHE; else echo "&nbsp;";?></td>
  455.       <td><?php if (isset($txtSGE)) echo $txtSGCE; else echo "&nbsp;";?></td>
  456.     </tr>
  457.     <tr>
  458.       <th scope="row"><?php if (isset($_POST['triClassif']) && $_POST['triClassif'] == 'Non Cadre') echo "IV";
  459.                       else if (isset($_POST['triClassif']) && $_POST['triClassif'] == 'Cadre') echo "D";
  460.                       else echo "&nbsp;";?>
  461.       </th>
  462.       <td><?php if (isset($txtDCD)) echo $txtDCD; else echo "&nbsp;";?></td>
  463.       <td><?php if (isset($txtDGD)) echo $txtDGD; else echo "&nbsp;";?></td>
  464.       <td><?php if (isset ($txtDLMD)) echo $txtDLMD; else echo "&nbsp;";?></td> 
  465.       <td><?php if (isset ($txtDOD)) echo $txtDOD; else echo "&nbsp;";?></td>
  466.       <td><?php if (isset($txtDTD)) echo $txtDTD; else echo "&nbsp;";?></td>
  467.       <td><?php if (isset($txtINFOD)) echo $txtINFOD; else echo "&nbsp;";?></td>
  468.       <td><?php if (isset($txtMKGD)) echo $txtMKGD; else echo "&nbsp;";?></td>
  469.       <td><?php if (isset($txtRHD)) echo $txtRHD; else echo "&nbsp;";?></td>
  470.       <td><?php if (isset($txtSGD)) echo $txtSGCD; else echo "&nbsp;";?></td>
  471.     </tr>
  472.     <tr>
  473.       <th scope="row"><?php if (isset($_POST['triClassif']) && $_POST['triClassif'] == 'Non Cadre') echo "III";
  474.                       else if (isset($_POST['triClassif']) && $_POST['triClassif'] == 'Cadre') echo "C";
  475.                       else echo "&nbsp;";?>
  476.       </th>
  477.       <td><?php if (isset($txtDCC)) echo $txtDCC; else echo "&nbsp;";?></td>
  478.       <td><?php if (isset($txtDGC)) echo $txtDGC; else echo "&nbsp;";?></td>
  479.       <td><?php if (isset($txtDLMC)) echo $txtDLMC; else echo "&nbsp;";?></td>
  480.       <td><?php if (isset($txtDOC)) echo $txtDOC; else echo "&nbsp;";?></td>
  481.       <td><?php if (isset($txtDTC)) echo $txtDTC; else echo "&nbsp;";?></td>
  482.       <td><?php if (isset($txtINFOC)) echo $txtINFOC; else echo "&nbsp;";?></td>
  483.       <td><?php if (isset($txtMKGC)) echo $txtMKGC; else echo "&nbsp;";?></td>
  484.       <td><?php if (isset($txtRHC)) echo $txtRHC; else echo "&nbsp;";?></td>
  485.       <td><?php if (isset($txtSGC)) echo $txtSGCC; else echo "&nbsp;";?></td>
  486.     </tr>
  487.     <tr>
  488.       <th scope="row"><?php if (isset($_POST['triClassif']) && $_POST['triClassif'] == 'Non Cadre') echo "II";
  489.                       else if (isset($_POST['triClassif']) && $_POST['triClassif'] == 'Cadre') echo "B";
  490.                       else echo "&nbsp;";?>
  491.       </th>
  492.       <td><?php if (isset($txtDCB)) echo $txtDCB; else echo "&nbsp;";?></td>
  493.       <td><?php if (isset($txtDGB)) echo $txtDGB; else echo "&nbsp;";?></td>
  494.       <td><?php if (isset($txtDLMB)) echo $txtDLMB; else echo "&nbsp;";?></td>
  495.       <td><?php if (isset($txtDOB)) echo $txtDOB; else echo "&nbsp;";?></td>
  496.       <td><?php if (isset($txtDTB)) echo $txtDTB; else echo "&nbsp;";?></td>
  497.       <td><?php if (isset($txtINFOB)) echo $txtINFOB; else echo "&nbsp;";?></td>
  498.       <td><?php if (isset($txtMKGB)) echo $txtMKGB; else echo "&nbsp;";?></td>
  499.       <td><?php if (isset($txtRHB)) echo $txtRHB; else echo "&nbsp;";?></td>
  500.       <td><?php if (isset($txtSGB)) echo $txtSGCB; else echo "&nbsp;";?></td>
  501.     </tr>
  502.     <tr>
  503.       <th scope="row"><?php if (isset($_POST['triClassif']) && $_POST['triClassif'] == 'Non Cadre') echo "I";
  504.                       else if (isset($_POST['triClassif']) && $_POST['triClassif'] == 'Cadre') echo "A";
  505.                       else echo "&nbsp;";?>
  506.       </th>
  507.       <td><?php if (isset($txtDCA)) echo $txtDCA; else echo "&nbsp;";?></td>
  508.       <td><?php if (isset($txtDGA)) echo $txtDGA; else echo "&nbsp;";?></td>
  509.       <td><?php if (isset($txtDLMA)) echo $txtDLMA; else echo "&nbsp;";?></td>
  510.       <td><?php if (isset($txtDOA)) echo $txtDOA; else echo "&nbsp;";?></td>
  511.       <td><?php if (isset($txtDTA)) echo $txtDTA; else echo "&nbsp;";?></td>
  512.       <td><?php if (isset($txtINFOA)) echo $txtINFOA; else echo "&nbsp;";?></td>
  513.       <td><?php if (isset($txtMKGA)) echo $txtMKGA; else echo "&nbsp;";?></td>
  514.       <td><?php if (isset($txtRHA)) echo $txtRHA; else echo "&nbsp;";?></td>
  515.       <td><?php if (isset($txtSGA)) echo $txtSGCA; else echo "&nbsp;";?></td>
  516.     </tr>
  517.    
  518.     <?php if (!$_GET['print']){?>
  519.     <tr align="center">
  520.       <td colspan="10"><input name="printtab" type="submit" value="Imprimer le tableau"
  521.     onclick="window.document.tableau.action='tableau.php?print=TRUE';"></td>
  522.     </tr>
  523.     <?php
  524.     }
  525.     ?>
  526.   </table>
  527. </form>
  528. <?php
  529. if ($_GET['print']) { echo '<div align="center"><a href="tableau.php">Revenir au tableau de répartition</a></div>'; imprimer();}
  530. if (!$_GET['print']) include ("_btm.php" );
  531. ?>




Merci bien de prendre du temps pour moi.


Message édité par Bruenor911 le 09-04-2008 à 16:30:50
Répondre à Bruenor911
coca25   09-04-2008 à 16:47:23
- 0 +

ligne 124: espace entre ' et C
ou mieux lg 122 espace après le where

------------------------------ Ne pas oublier le [resolu] pour finir le sujet.
Penser à voir les tutos, ca peut aider!
 Répondre à coca25
RedTux   09-04-2008 à 16:53:00
- 0 +

En plus t'as pas fait l'erreur apres :

 
Code :
  1. .        $select .= 'Coef between 0 and 1000'; // ligne 124 sur ton post
  2. .        $select .= ' Coef="'.$_POST['triCoefMin'].'"'; //ligne 135 sur ton post
 
Spoiler :

J'en profite pour dire bonjour à coca25 ! Ça va m'sieur ? :D


Message édité par RedTux le 09-04-2008 à 16:53:21
------------------------------ N'oubliez pas le [Résolu] dans le titre si vous êtes satisfait.
Les règles du Forum - À lire absolument
 Répondre à RedTux
coca25   09-04-2008 à 17:37:46
- 0 +

:jap: zen, tranquille

 

bon retour (t'avais disparu des écrans :))

Message cité 1 fois
Message édité par coca25 le 09-04-2008 à 17:38:02
------------------------------ Ne pas oublier le [resolu] pour finir le sujet.
Penser à voir les tutos, ca peut aider!
 Répondre à coca25
RedTux   09-04-2008 à 17:39:31
- 0 +

coca25 a écrit :

bon retour (t'avais disparu des écrans :))



C'est pas un vrai retour ... Je m'ennuie un peu au taff donc je passe voir ce qu'y ce passe ...

Spoiler :

IDN's lover ... snif ... [:zoon62:2]

------------------------------ N'oubliez pas le [Résolu] dans le titre si vous êtes satisfait.
Les règles du Forum - À lire absolument
 Répondre à RedTux
Bruenor911   10-04-2008 à 09:02:54
- 0 +

Merci beaucoup, ça m'aide vraiment et peut-être qu'à force je serais moins nul.

Répondre à Bruenor911
Créer un nouveau sujet Répondre
Tom's Guide > Forum > Programmation > Pb php requête base de données [Résolu]
Aller à :

Il y a 417 utilisateurs connus et inconnus. Pour voir la liste des connectés connus, cliquez ici.

Plan du forum
Forum Bestofmedia ©
2000-2009 Bestofmedia Group
Page générée en 0,924 secondes
Attention

Vous allez répondre sur un sujet resté inactif pendant plus de 6 mois.
Assurez-vous d'apporter des éléments nouveaux à la discussion avant de poursuivre.

Répondre Annuler
Liens