1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
|
$query =
"select
pid_log,
jobname_log,
dbtimestamp_log,
dbendstamp_log,
timediff(`dbendstamp_log`,`dbtimestamp_log`) AS Duree,
script_log,
args_log,
returncode_log
from
log
where true
AND message_log!='Wrapper End'
AND dbtimestamp_log between '".$date2."' and '".$date1."'
UNION
select
pid_log,
jobname_log,
dbtimestamp_log,
dbendstamp_log,
timediff(`dbendstamp_log`,`dbtimestamp_log`) AS Duree,
script_log,
args_log,
returncode_log
from
log
where true
AND message_log!='Wrapper End'
AND dbtimestamp_log between '".$date3."' and '".$date4."'
order by dbtimestamp_log DESC, returncode_log DESC
";
$results = mysql_query ($query);
while ($rows[] = mysql_fetch_array($results));
mysql_free_result ($results); |
