voila mon code de la page
Portfolio :,
<option></option>
<?php
include("Connection.php");
$query = mysql_query("SELECT * FROM Portfolio");
echo '<select>';
while ($result = mysql_fetch_assoc($query)) {
echo '<option value="'.$result['Portfolio'].'">'.$result['Portfolio'].'</option>';
}
mysql_close($connect);
?>
</select>,
<form method=\"POST\">
Contract :,
<select name="Con">
<option></option>
<?php
include("Connection.php");
$query = mysql_query("SELECT * FROM Contract");
echo '<select>';
while ($result = mysql_fetch_assoc($query)) {
echo '<option value="'.$result['Contract'].'">'.$result['Contract'].'</option>';
}
mysql_close($connect);
?>
</select>,
,
Global status : Open ,
Closed ,
Foreseen ,
,
,
</form>
<!--, -->
<form action="creation_update.php">
<table id="rightbl" cellpadding="2" cellspacing="0">
<tr class="th1b">
<th class="th1">Contract</th>
<th class="th1">Task Ref</th>
<th class="th1">Task Type</th>
<th class="th1">Title</th>
<th class="th1">Description</th>
<th class="th1">Raised By</th>
<th class="th1">Date Raised</th>
<th class="th1">Status</th>
<th class="th1">Requested J2</th>
<th class="th1">Assigned to</th>
<th class="th1">PM costs</th>
<th class="th1">TQF costs</th>
<th class="th1">MEP costs </th>
<th class="th1">Total costs France</th>
<th class="th1">Total costs Morocco</th>
<th class="th1">Total costs</th>
<th class="th1">OTC Dir approval </th>
<th class="th1">initial J2 </th>
<th class="th1">final J2 </th>
<th class="th1">Date Closed </th>
</tr>
<?php
include("Connection.php");
$retour = mysql_query('SELECT distinct Contract, Task_Ref,
Type , Title, Description, Raised_By, Date_Raised,Status,Requested_J2,PM_Costs,
TQF_costs,OTC_Dir_approval,Date_Closed
FROM Contract, Task, Task_Type,Status,Task_Progress
WHERE
Contract.Id_Contract=Task.Id_Contract and
Task_Type.Id_Task_Type = Task.Id_Task_Type
and Status.Id_Status=Task_Progress.Id_Status
' );}
while ($donnees = mysql_fetch_array($retour))
{
?>
<tr>
<!--<TD></TD-->
<td>[ <?php echo stripslashes($donnees['Contract']); ?>]</td>
<td><?php echo stripslashes($donnees['Task_Ref']); ?></td>
<td><?php echo stripslashes($donnees['Type']); ?></td>
<td><?php echo stripslashes($donnees['Title']); ?></td>
<td><?php echo stripslashes($donnees['Description']); ?></td>
<td><?php echo stripslashes($donnees['Raised_By']); ?></td>
<td><?php echo stripslashes($donnees['Date_Raised']); ?></td>
<td><?php echo stripslashes($donnees['Status']); ?></td>
<td><?php echo stripslashes($donnees['Requested_J2']); ?></td>
<td><?php echo stripslashes($donnees['']); ?></td>
<td><?php echo stripslashes($donnees['']); ?></td>
<td><?php echo stripslashes($donnees['TQF_costs']); ?></td>
<td><?php echo stripslashes($donnees['MEP_costs']); ?></td>
<td><?php echo stripslashes($donnees['']); ?></td>
<td><?php echo stripslashes($donnees['']); ?></td>
<td><?php echo stripslashes($donnees['']); ?></td>
<td><?php echo stripslashes($donnees['OTC_Dir_approval']); ?></td>
<td><?php echo stripslashes($donnees['']); ?></td>
<td><?php echo stripslashes($donnees['']); ?></td>
<td><?php echo stripslashes($donnees['Date_Closed']); ?></td>
</tr>
<?php
}
?>