1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| $Project2=$_POST['Project'];
$Q_JobList = "Select job,TO_CHAR(moment,'DD/MM/YYYY') AS DATEJOB,TO_CHAR (MOMENT-DURATION/60/60/24/1000,'HH24:mi:ss') AS BEGIN,
(SYSDATE-MOMENT)*24*60*60 AS RUNNINGDURATION,
TO_CHAR(moment,'HH24:mi:ss') AS END,
DURATION,message,message_type AS STATE,PID
FROM DFM_STAT
WHERE PROJECT='".$Project2."'
order by message_type asc, 2 DESC, 5 DESC";
$statement = oci_parse ($dblink, $Q_JobList);
oci_execute ($statement);
//********************Structure of Query display*****************************
//************************************************************************************
while($L_JobList = oci_fetch_array($statement, OCI_ASSOC)){
echo "<tr colspan='7' class='titreblanc'>";
echo "<td>".$L_JobList[JOB]."</td>";
echo "<td>".$L_JobList[DATEJOB]."</td>";
echo "<td>".$L_JobList[END]."</td>";
echo "<td>".$L_JobList[BEGIN]."</td>";
} |
Partager