narrd.php

来自「电子派单系统」· PHP 代码 · 共 36 行

<?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%>";
echo "<tr><th>序号<th>用户名称<th>联系人<th>联系号码<th>地址<th>付费电话<th>故障关联电话<th>联系时段<th>受理人<th>经理人编号<tr>";
echo "<tr>";
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_query("select * from flow where sn='$deliver[sn]' and snord='$maxsn[0]' and ans='0' and goin='$_SESSION[gdpt]'") or die("Invalid query: " .mysql_error());
if (mysql_num_rows($tflag)>0){


for ($j=1;$j<=mysql_num_rows($tflag);$j++){
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[contm]</td>";
echo "<td>$deliver[man]</td>";
echo "<td>$deliver[mgid]</td>";
echo "</tr>";
}
}
echo "</table>";
}



?>