"; //echo ""; echo "

"; echo "

"; if(!empty($_POST)){ $selection=""; for($i=0;$i"."\"$value[0]\" and "; } if(!empty($value[1])){ if($names[$i] == "RunStartTime") $value[1]=$value[1]." 23:59:59"; $selection.=$tables[$i].".".$names[$i]."<="."\"$value[1]\" and "; } } } } //if(!empty($selection)){ if(!empty($_POST)){ $sort=""; if(!empty($_POST["order"]) && ($_POST["order"][1]=="asc" || $_POST["order"][1]=="desc")){ $sort = "order by ".$_POST["order"][0]." ".$_POST["order"][1]; } $query = "select * from RunInfo, AnalysisInfo, EndRunInfo ". "where $selection AnalysisInfo.RunInfo_RunNumber = RunInfo.RunNumber and EndRunInfo.RunInfo_RunNumber = RunInfo.RunNumber ". "and endrunID=(SELECT endrunID from EndRunInfo where RunInfo_RunNumber = RunNumber order by endrunID DESC limit 1) ". "and anaID=(SELECT anaID from AnalysisInfo where RunInfo_RunNumber = RunNumber order by anaID DESC limit 1) ". // "and anaID=(SELECT anaID from AnalysisInfo where $selection RunInfo_RunNumber = RunNumber order by anaID DESC limit 1) ". $sort; $result = mysql_query($query); $nrows = mysql_num_rows($result); if($nrows>0){ $limit = 50; if(!empty($_POST["limit"])){ $limit = $_POST["limit"]; } $totalpages=ceil($nrows/$limit); $page=1; if(!empty($_POST["page"])){ if($_POST["page"]<=$totalpages){ $page = $_POST["page"]; } } /* $pagestr="

Page $page of $totalpages: "; for($k=1;$k<=$totalpages;$k++){ if($k!=$page){ $pagestr.="$k "; }else{ $pagestr.="[$k] "; } } $pagestr.=" | Fount $nrows runs!!!

"; */ $pagestr="

$nrows runs Page $page of $totalpages "; if($totalpages>1){ $pre = $page-1; $nex = $page+1; if($page!=1){ $pagestr.="« Previous"; }else{ $pagestr.="« Previous"; } $pagestr.=" "; if($page!=$totalpages){ $pagestr.="Next »"; }else{ $pagestr.="Next »"; } } $pagestr.="

"; echo "

$pagestr

\r". "\r"; $class="cell1"; mysql_data_seek($result,($page-1)*$limit); $num=0; while($row = mysql_fetch_array($result, MYSQL_ASSOC)){ if($class=="cell1") $class="cell2"; else $class="cell1"; echo "\r"; $num++; if($num>=$limit) break; } echo "

RunStartTime	Kinematic	Production	Run	Target	Energy	Time	Events	Expert
". $row["RunStartTime"]."	". $row["KineName"]."	". $row["Production"]."	". "".$row["RunNumber"]."	". $row["TargetName"]."	". $row["Energy"]."	". $row["Time"]."	". $row["Events"]."	". $row["UserName"]."

$pagestr