tmp.php

电子派单系统

<?php
session_start();
include("resp.inc");
resp_db_connect_i();
$tmp=mysql_query("select sn,ftype,ttime-stime as dtime from deliver where tflag='1' and datediff(now(),stime)='1' order by dtime desc");
if (mysql_num_rows($tmp)<1) {echo "<center><font size=+3>目前暂无销帐清单</font></center>";}else{
echo "<center><caption><font size=+3><B>前日销帐清单</B></font></caption></center>";
echo "<table align=center border=1px width=96%>";
echo "<tr><th>序号<th>故障原因<th>流程数<th>处理时长</tr>";
for ($i=1;$i<=mysql_num_rows($tmp);$i++){
$maxsn=mysql_fetch_array(mysql_query("select max(snord) from flow where sn=$opt[sn]"));
$opt=mysql_fetch_array($tmp);
echo "<tr><td><a href=\"dp.php?sn=$opt[sn]\">$opt[sn]</a></td>
	 <td>$opt[ftype]</td>

	 <td>$maxsn[0]</td>
	<td>$opt[dtime]</td></tr>";
}
echo "</table>";
}
?>