run_number;
$subquery="select NumCorHadron,IntLumEndcapEE from OnlineLum where run_number=$RunNo limit 1";
$subresult=mysql_query($subquery,$db);
while($subrow = mysql_fetch_object($subresult))
{
$SumHadron += $subrow->NumCorHadron;
$SumIntLum += $subrow->IntLumEndcapEE;
}
}
?>
Run Information !!!
";
echo "run number | star time | end time | total_event | NumCorHadron | IntLumEndcapEE | conclusion | Noise | SubDetectorInfo |
";
while($row = mysql_fetch_object($result))
{
$ST10 = strtotime($row->startTime)-5*60;
$ST10_str = date("Y-m-d H:i:s",$ST10);
$ET10 = strtotime($row->endTime)+5*60;
$ET10_str = date("Y-m-d H:i:s",$ET10);
$RunNo = $row->run_number;
//echo "$RunNo";p
$subquery="select NumCorHadron,IntLumEndcapEE from OnlineLum where run_number=$RunNo limit 1";
$subresult = mysql_query($subquery,$db);
//echo "$subquery";
while($subrow = mysql_fetch_object($subresult))
{
$Hadron = $subrow->NumCorHadron;
$IntLum = $subrow->IntLumEndcapEE;
}
printf(" %s | %s | %s | %s | %s | %s | %s | %s | %s |
",$row->run_number,$row->startTime,$row->endTime,$row->total_event,$Hadron,$IntLum,$row->conclusion,"Run Noise","GetSubDeteInfo");
}
echo "";
mysql_close($db);
?>