at.php

电子派单系统

<?php
session_start();
include("resp.inc");
resp_db_connect_i();
$tmp=mysql_query("select * from deliver where tflag='0'");
echo "<table border=1px align=center width=96%>";
for ($i=1;$i<=mysql_num_rows($tmp);$i++){
$deliver=mysql_fetch_array($tmp);
$maxsn=mysql_fetch_array(mysql_query("select max(snord) from flow where sn=$deliver[sn]"));

$tflag=mysql_fetch_array(mysql_query("select tflag from flow where sn=$deliver[sn] and snord=$maxsn[0]"));

if ($tflag[0]){
echo "<tr><th>序号<th>用户名称<th>联系人<th>联系号码<th>地址<th>付费电话<th>故障关联电话<th>联系时段<th>受理人<th>经理人编号<tr>";
echo "<tr>";
echo "<td><a href=\"dp.php?sn=$deliver[sn]\">$deliver[sn]</a></td>";
echo "<td>$deliver[name]</td>";
echo "<td>$deliver[stdman]</td>";
echo "<td>$deliver[contact]</td>";
echo "<td>$deliver[addr]</td>";
echo "<td>$deliver[payph]</td>";
echo "<td>$deliver[insph]</td>";
echo "<td>$deliver[man]</td>";
echo "<td>$deliver[mgid]</td>";
echo "<td>$deliver[stime]</td>";
echo "</tr>";
$dum=$dum+1;
}
}
if ($dum<1) echo "<div align=center><font size=+3 ><B>目前无待销故障</font></div>";
echo "</table>";
?>