Listes liées+ Base de donéees

<?php

	include "modules/adodb/adodb.inc.php";
	include "config/config.php";
// Connexion a la base de donnees  

$db = NewADOConnection("oci8");
$cstr = "(DESCRIPTION=(ADDRESS=(PROTOCOL=$PROTOCOL)(HOST=$HOST)(PORT=$PORT))(CONNECT_DATA=(SID=$SID)))";
$db->Connect($cstr, $USER, $PWD);


$req = "select distinct processes.heading from processes, requests where requests.idprocess=processes.idprocess order by processes.heading ASC "; 
$res=$db->Execute($req);

?>

<table>
<td>
	<tr>
	<td><label for="pros2">Veuillez sélectionner le <font COLOR="#39C0F"><em>processus</em></font> concerné :</label></td>
	<td><select name="pros2" id="id_pros2" onChange="submit()">
	<option>-- Choisissez --</option>
		
<?php
			while ($data=$res->FetchRow()){
			
?>

<option value="<?php echo $data[0]?>" <?php if($_POST['pros2']==$data[0]){echo "selected";} ?>><?php echo $data[0]?></option>

<?php
			}
?>
       </select> 
       </td>
	   </tr>
</td>

//***Jusqu'ici c'est ok***

<br>
<br>

<?php	
	if(isset($_POST['pros2']) && $_POST['pros2']!="")
	{

$req = "select procedures.heading from procedures, requests where requests.idprocess='".$_POST['pros2']."' AND procedures.idprocedure=requests.idprocedure order by requests.idprocedure ASC" ;
$res=$db->Execute($req);
?>

<tr>
	<td><label>Veuillez sélectionner la <font COLOR="#39C0F"><em>requête</em></font> concernée :</label></td>
	<td><select name="req1" id="id_req1">
	<option>-- Choisissez --</option>
		
<?php
			while ($data=$res->FetchRow()){
			
?>

<option value="<?php echo $data[0]?>" ><?php echo $data[1]?></option>
<?php
	}
?>
	</select> 
	</td>
</tr>

<?php
}
?>