Pourquoi, cela n'affiche t il pas ce que je veux?

Pourquoi, cela n'affiche t il pas ce que je veux? - PHP - Programmation

Marsh Posté le 27-04-2006 à 16:36:09    

Bonjour,
 
Je suis en train de réaliser une base de données. Cependant, je bute sur un petit problème d'affichage. En fait quand je clique sur un bouton, celà lance l'affichage d'une liste de nom avec a coté de chacun, un bouton pour afficher son profil. Cepndant, quand je lance un tri sur cette liste, et que j'appuie sur le bouton profil, cela m'affiche la page profil, mais vierge, sans données... et le pire, c'est que j'ai fait un copier coller... donc je ne vois pas pourquoi ca marche pour l'un et pas pour l'autre...
 
Voici le code, si vous pouviez y jeter un coup d'oeil et m'aider à trouver mon erreur...
 

Code :
  1. table width="900px" style="margin-left:7px; margin-right:7px; margin-top:7px; margin-bottom:7px; background-color:#99CCFF;" cellpadding="10px" cellspacing="0">
  2. <caption>Employees</caption>
  3.      <tr valign="middle">
  4.       <td width="100px" valign="middle">See/Modify</td>
  5.   <td style="margin-left:7px; border-left:1px solid; border-bottom:1px solid;" width="120px" valign="middle"><big>Name</big></td>
  6.   <td style="margin-left:7px; border-left:1px solid; border-bottom:1px solid;" valign="middle"><big>Firstname</big></td>
  7.   <td style="margin-left:7px; border-left:1px solid; border-bottom:1px solid;" valign="middle"><big>Function</big></td>
  8.   <td style="margin-left:7px; border-left:1px solid; border-bottom:1px solid;" valign="middle"><big>Group</big></td>
  10.      </tr>
  11. <?php
  12.  
  13. if (isset($_GET['i']))
  14. {
  15.    $test=$_GET['i'];
  17.    switch ($test)
  18.    {
  19.      case 'f':
  20.  
  21.   $sql="SELECT E.EMP_CODE AS CODE, EMP_NAME, EMP_FIRSTNAME, FUN_DESIGNATION, DES_NAME FROM EMPLOYEE E, FUNCTION, DESIGN_GROUP WHERE E.DES_CODE = DESIGN_GROUP.DES_CODE AND E.FUN_CODE = FUNCTION.FUN_CODE AND FUNCTION.FUN_CODE = ".$_POST['employee_function']." ORDER BY `DES_NAME` ASC;";
  22.       $result=mysql_query($sql);
  24.   for($j=0; $j<mysql_num_rows($result); $j++)
  25.   {
  27.    $num = mysql_result($result, $j, "EMP_CODE" );
  28.    $name = mysql_result($result, $j, "EMP_NAME" );
  29.    $first = mysql_result($result, $j, "EMP_FIRSTNAME" );
  30.    $func = mysql_result($result, $j, "FUN_DESIGNATION" );
  31.    $dg = mysql_result($result, $j, "DES_NAME" );
  34.       echo '<tr height="75px">';
  35.   echo '<td align="center" valign="middle"><form method="POST" action="../?i=3e"><input name="designer" type="hidden" value="'.$num.'"><input type="submit" value="&times;" class="bouton"></form></td>';
  36.   echo '<td style="margin-left:7px; border-left:1px solid;" valign="middle">'.$name.'</td>';
  37.   echo '<td style="margin-left:10px; border-left:1px solid;" valign="middle">'.$first.'</td>';
  38.   echo '<td style="margin-left:7px; border-left:1px solid;" valign="middle">'.$func.'</td>';
  39.   echo '<td style="margin-left:10px; border-left:1px solid;" valign="middle">'.$dg.'</td>';
  40.   echo '<td style="margin-left:7px; border-left:1px solid;" valign="middle">';
  42.      echo '</tr>';
  43.      }   
  44.       break;
  45.  
  46.      case 'g':
  47.  
  48.   $sql="SELECT E.EMP_CODE AS CODE, EMP_NAME, EMP_FIRSTNAME, FUN_DESIGNATION, DES_NAME FROM EMPLOYEE E, FUNCTION, DESIGN_GROUP WHERE E.DES_CODE = DESIGN_GROUP.DES_CODE AND E.FUN_CODE = FUNCTION.FUN_CODE AND DESIGN_GROUP.DES_CODE = ".$_POST['employee_group']." ORDER BY `EMP_NAME` ASC;";
  49.       $result=mysql_query($sql);
  51.   for($j=0; $j<mysql_num_rows($result); $j++)
  52.   {
  54.    $num = mysql_result($result, $j, "EMP_CODE" );
  55.    $name = mysql_result($result, $j, "EMP_NAME" );
  56.    $first = mysql_result($result, $j, "EMP_FIRSTNAME" );
  57.    $func = mysql_result($result, $j, "FUN_DESIGNATION" );
  58.    $dg = mysql_result($result, $j, "DES_NAME" );
  61.       echo '<tr height="75px">';
  62.   echo '<td align="center" valign="middle"><form method="POST" action="../?i=3e"><input name="designer" type="hidden" value="'.$num.'"><input type="submit" value="&times;" class="bouton"></form></td>';
  63.   echo '<td style="margin-left:7px; border-left:1px solid;" valign="middle">'.$name.'</td>';
  64.   echo '<td style="margin-left:10px; border-left:1px solid;" valign="middle">'.$first.'</td>';
  65.   echo '<td style="margin-left:7px; border-left:1px solid;" valign="middle">'.$func.'</td>';
  66.   echo '<td style="margin-left:10px; border-left:1px solid;" valign="middle">'.$dg.'</td>';
  67.   echo '<td style="margin-left:7px; border-left:1px solid;" valign="middle">';
  71.      echo '</tr>';
  72.      }   
  73.       break;
  74.  
  75.      default:
  76.  
  77.     $sql="SELECT `EMP_CODE`, `EMP_NAME`, `EMP_FIRSTNAME`, `FUN_DESIGNATION`, `DES_NAME` FROM `EMPLOYEE`, `FUNCTION`, `DESIGN_GROUP` WHERE EMPLOYEE.FUN_CODE = FUNCTION.FUN_CODE AND EMPLOYEE.DES_CODE = DESIGN_GROUP.DES_CODE ORDER BY `DES_NAME` ASC;";
  78. $result=mysql_query($sql);
  80. for($j=0; $j<mysql_num_rows($result); $j++)
  81. {
  83. $num = mysql_result($result, $j, "EMP_CODE" );
  84. $name = mysql_result($result, $j, "EMP_NAME" );
  85. $first = mysql_result($result, $j, "EMP_FIRSTNAME" );
  86. $func = mysql_result($result, $j, "FUN_DESIGNATION" );
  87. $dg = mysql_result($result, $j, "DES_NAME" );
  90.  
  91.     echo '<tr height="75px">';
  92.   echo '<td align="center" valign="middle"><form method="POST" action="../?i=3e"><input name="designer" type="hidden" value="'.$num.'"><input type="submit" value="&times;" class="bouton"></form></td>';
  93.   echo '<td style="margin-left:7px; border-left:1px solid;" valign="middle">'.$name.'</td>';
  94.   echo '<td style="margin-left:10px; border-left:1px solid;" valign="middle">'.$first.'</td>';
  95.   echo '<td style="margin-left:7px; border-left:1px solid;" valign="middle">'.$func.'</td>';
  96.   echo '<td style="margin-left:10px; border-left:1px solid;" valign="middle">'.$dg.'</td>';
  97.   echo '<td style="margin-left:7px; border-left:1px solid;" valign="middle">';
  101.      echo '</tr>';
  102.      }   
  103.       break;
  104.    }
  105. }
  106. else
  107. { 
  108.  $sql="SELECT `EMP_CODE`, `EMP_NAME`, `EMP_FIRSTNAME`, `FUN_DESIGNATION`, `DES_NAME` FROM `EMPLOYEE`, `FUNCTION`, `DESIGN_GROUP` WHERE EMPLOYEE.FUN_CODE = FUNCTION.FUN_CODE AND EMPLOYEE.DES_CODE = DESIGN_GROUP.DES_CODE ORDER BY `DES_NAME` ASC;";
  109. $result=mysql_query($sql);
  111. for($j=0; $j<mysql_num_rows($result); $j++)
  112. {
  114. $num = mysql_result($result, $j, "EMP_CODE" );
  115. $name = mysql_result($result, $j, "EMP_NAME" );
  116. $first = mysql_result($result, $j, "EMP_FIRSTNAME" );
  117. $func = mysql_result($result, $j, "FUN_DESIGNATION" );
  118. $dg = mysql_result($result, $j, "DES_NAME" );
  121.  
  123.     echo '<tr height="75px">';
  124.   echo '<td align="center" valign="middle"><form method="POST" action="../?i=3e"><input name="designer" type="hidden" value="'.$num.'"><input type="submit" value="&times;" class="bouton"></form></td>';
  125.   echo '<td style="margin-left:7px; border-left:1px solid;" valign="middle">'.$name.'</td>';
  126.   echo '<td style="margin-left:10px; border-left:1px solid;" valign="middle">'.$first.'</td>';
  127.   echo '<td style="margin-left:7px; border-left:1px solid;" valign="middle">'.$func.'</td>';
  128.   echo '<td style="margin-left:10px; border-left:1px solid;" valign="middle">'.$dg.'</td>';
  129.   echo '<td style="margin-left:7px; border-left:1px solid;" valign="middle">';
  133.      echo '</tr>';
  134.     }
  135. }
  136. ?>


 
 
Je vous remercie d'avance
Lyim

Reply

Marsh Posté le 27-04-2006 à 16:36:09   

Reply

Marsh Posté le 27-04-2006 à 17:10:24    

C'est bon, j'ai trouvé en fait... c'était tout con, mais j'avais pas vu...
 
ca venait de là:  
 

Code :
  1. $sql="SELECT E.EMP_CODE AS CODE, EMP_NAME, EMP_FIRSTNAME, FUN_DESIGNATION, DES_NAME FROM EMPLOYEE E, FUNCTION, DESIGN_GROUP WHERE E.DES_CODE = DESIGN_GROUP.DES_CODE AND E.FUN_CODE = FUNCTION.FUN_CODE AND DESIGN_GROUP.DES_CODE = ".$_POST['employee_group']." ORDER BY `EMP_NAME` ASC;";
  3.               $result=mysql_query($sql);
  6.             for($j=0; $j<mysql_num_rows($result); $j++)
  8.             {   
  11.                 $num = mysql_result($result, $j, "EMP_CODE");


 
 
Il fallait simplement que je remplace EMP_CODE par CODE... c'est tout! Cinq heure de perdues!
 
Merci quand même!
Lyim


Message édité par lyim le 27-04-2006 à 17:12:21
Reply

Sujets relatifs:

Leave a Replay

Make sure you enter the(*)required information where indicate.HTML code is not allowed