modification dans la bd d un champ

   <?php session_start(); ?>


<div id="container">
 
  <div id="header">
    <img src="header.JPG" width="970" height="111" />
    <!-- fin de #header -->
  </div>
  
  <div id="content">
         <div id="l_col">     
		          	 <div class="ali">
              
		          	 	 <ul>
              
                            <li><a href="gertest.php">Etat de demande</a></li>
                             <li><a href="deco.php">Deconection</a></li>
                       </ul>
                             <form id="form1" name="form1" method="post" action="">
                  	      <label>
					   
                  	      </label>
                      <table width="220" border="0">
                        <tr> <td width="103" align="right"> 
					            <input type="text" name="textfield" id="textfield" size="10" />
                              </td>
                              <td width="99"> 
                                 <input name="voyer" type="submit" class="button" id="voyer" value="Recrcheh" />
                              </td>
                         </tr>     
                        <tr>
                          <td colspan="3" align="">    Matricule
                            :
                            <input type="radio" name="radio" id="radio" value="radio" />
                          </label></td>
                        </tr>
                           <tr>
                          <td colspan="3">    Service
                            :&nbsp;&nbsp;
                            <select id="list2" name="list2" >
                              <option selected="selected" value="mpl">mpl</option>
                              <option selected="selected" value="rcl">rcl</option>
                              <option selected="selected" value="dl">dl</option>

                            </select>
</label></td>
                        </tr>
                      </table>
                      <br/>
       	      </form>
                         
		          	 </div>
		 </div>
         <div id="r_col" >
<form  method="post" action=""  name="frm_pass" >
  <p>
    <?php if (!isset($_POST['voyer'])) 
{
 $id=mysql_connect('localhost','root','');
	     mysql_select_db('ts',$id);
// lancement de la requete
$sql = 'SELECT s.libelle,a.Matricule,a.Nom,a.Prenom,d.Type,d.DateDemende,d.user,d.user FROM agents as a,demande as d,service as s where a.codemande=d.Codemande and a.Matricule=s.Matricule ';
$sql1='select Etat from demande';
// on lance la requête (mysql_query) et on impose un message d'erreur si la requête ne
$req1 = mysql_query($sql1) or die('Erreur SQL !<br />'.$sql.'<br />'.mysql_error());
$req = mysql_query($sql) or die('Erreur SQL !<br />'.$sql.'<br />'.mysql_error());
// on recupere le resultat sous forme d'un tableau
echo"<table border='3'  >

        <tr>
		    <td>service </td>
			<td>Matricule </td>
			<td>Nom </td>
			<td>Prenom </td>	
			<td>Type demande </td>	
			<td>dateEnvoi de serveur </td>
			<td>Last date </td>
			<td>User </td>
			<td>Etat </td>";

while($data = mysql_fetch_row($req)){;
$data1 = mysql_fetch_row($req1);
// on libère l'espace mémoire alloué pour cette interrogation de la base
//mysql_free_result ($req);

echo"<tr>";
for($i=0;$i<count($data);$i++){

 echo"<td> $data[$i] </td>"
;}
for($i=0;$i<count($data1);$i++){

 echo"<td> "  ?>
    <select id="list" name="list" >
      <option selected="selected" value="encours">encours</option>
      <option selected="selected" value="cloturé">cloturé</option>
      <option selected="selected" value="Fermer">Fermer</option>
      <option selected="selected" value="<?php echo"$data1[$i]";?>"><?php echo"$data1[$i]";?></option>
    </select>
    <?php  echo"</td>"
;
}}
 
echo"</tr>";
echo"</table>" ;
} else {
?>
    </br>
    <?php  if (isset($_POST['voyer'])) 
{
					  if (isset($_POST['radio'])) 
{
				  $log=$_POST['textfield']; 
				$id=mysql_connect('localhost','root','');
	     mysql_select_db('ts',$id);
// lancement de la requete
$sql = 'SELECT s.libelle,a.Matricule,a.Nom,a.Prenom,d.Type,d.DateDemende,d.user,d.user FROM agents as a,demande as d,service as s where a.codemande=d.Codemande and a.Matricule=s.Matricule and a.Matricule ='.$log; 
$req = mysql_query($sql);
if(mysql_num_rows($req)==0)
		{
		echo "aucune information sur se client n existe dans la base de donné";
		
		}
else{
// on recupere le resultat sous forme d'un tableau
echo"<table border='3'  >

        <tr>
		    <td>service </td>
			<td>Matricule </td>
			<td>Nom </td>
			<td>Prenom </td>	
			<td>Type demande </td>	
			<td>dateEnvoi de serveur </td>
			<td>Last date </td>
			<td>User </td>
			<td>Etat </td>";

$data = mysql_fetch_row($req);
// on libère l'espace mémoire alloué pour cette interrogation de la base
mysql_free_result ($req);

echo"<tr>";
for($i=0;$i<count($data);$i++){

 echo"<td> $data[$i] </td>"
;}
				
echo"</tr>";}
echo"</table>" ;  
}else {  if (isset($_POST['radi'])) 
{
				  $log=$_POST['textfield']; 
				$id=mysql_connect('localhost','root','');
	     mysql_select_db('ts',$id);
// lancement de la requete
$sql = 'SELECT s.libelle,a.Matricule,a.Nom,a.Prenom,d.Type,d.DateDemende,d.user,d.user FROM agents as a,demande as d,service as s where a.codemande=d.Codemande and a.Matricule=s.Matricule and s.sigle like '.$log; 
$req = mysql_query($sql);
if($req==0)
		{
		echo "aucune information sur se client n existe dans la base de donné";
		
		}
else{
// on recupere le resultat sous forme d'un tableau
echo"<table border='3'  >

        <tr>
		    <td>service </td>
			<td>Matricule </td>
			<td>Nom </td>
			<td>Prenom </td>	
			<td>Type demande </td>	
			<td>dateEnvoi de serveur </td>
			<td>Last date </td>
			<td>User </td>
			<td>Etat </td>";

$data2 = mysql_fetch_row($req);
echo"<tr>";
for($i=0;$i<count($data2);$i++){

 echo"<td> $data2[$i] </td>"
;}
				
echo"</tr>";}
echo"</table>" ;  
}else { 
}

}
}
}
				  ?>
  </p>
<input name="envoyer" type="submit" class="button" id="envoyer" value="Envoyer" />
                     <input name="anul" type="submit" class="button" id="anul" value="Annuler"  />
        <?php 
 $id=mysql_connect('localhost','root','');
	     mysql_select_db('ts',$id);

if(isset($_POST['envoyer'])) {
$s=$_POST['list'];
		echo $s ;
		$t='UPDATE demande SET Etat ='.$_POST['list'].'where Etat="hhr"';

        mysql_query($t);
	//	echo $s;
		
		;}else {echo"erreur";
   }  
?>
</form>
      </label>
    </div>
                   </LABEL></td>
               </tr>
             </table>
           		
           </form>
  </div>	 
  <div id="footer">