<tr>
<td colspan="4">======= 客 户 操 作
<?
//取出已激活卡号
//实现分页
$sql_off="select * from com_info where com_level= '1' ";
$result_off=mssql_query($sql_off);
$result_off_number=mssql_num_rows($result_off);
?>
</td>
</tr>
<tr>
<td colspan="3">
<div align="left">---- 客户列表 (共有<font color="#CC0000">
<? echo $result_off_number; ?>
</font>名客户) </div>
</td>
<td width="20%"> </td>
</tr>
<tr>
<td width="18%">客户ID </td>
<td width="46%">公司名称 </td>
<td width="16%">订单状态 </td>
<td width="20%">[ <font color="#CC0000">删 除</font> ] </td>
</tr>
<?
mssql_field_seek($result_off,20);
for ($i;$i<=20;$i++)
{
$record_m=@mssql_fetch_object($result_off);
?>
<tr>
<td width="18%">
<? echo $record_m->com_id; ?>
</td>
<td width="46%"><a href="user_show.php?com_id=<? echo $record_m->com_id ?>">
<? echo $record_m->com_company; ?>
</a> </td>
<td width="16%">
<?
//取出订单状态
$sql_o="select * from order_info where order_com_id = '$record_m->com_id' order by order_id desc";
$result_o=@mssql_query($sql_o);
$record_o=@mssql_fetch_object($result_o);
$result_o_number=@mssql_num_rows($result_o);
if ($result_o_number==0)
{
echo "没有订单";
}
else
{
echo "<a href=\"order_show.php?order_id=".$record_o_->order_id."\">有".$result_o_number."单"; }
?>
</td>
<td width="20%">[ <font color="#CC0000"><a href="user.php?action=del&com_id=<? echo $record_m->com_id; ?>">删
除</a></font> ] </td>
</tr>
<?
}
?>
<tr>
<td colspan="4">
共有<font color="#CC0000"><? echo $page_number; ?></font>页/<font color="#CC0000">20</font>条/页
</td>
</tr>
<td colspan="4">======= 客 户 操 作
<?
//取出已激活卡号
//实现分页
$sql_off="select * from com_info where com_level= '1' ";
$result_off=mssql_query($sql_off);
$result_off_number=mssql_num_rows($result_off);
?>
</td>
</tr>
<tr>
<td colspan="3">
<div align="left">---- 客户列表 (共有<font color="#CC0000">
<? echo $result_off_number; ?>
</font>名客户) </div>
</td>
<td width="20%"> </td>
</tr>
<tr>
<td width="18%">客户ID </td>
<td width="46%">公司名称 </td>
<td width="16%">订单状态 </td>
<td width="20%">[ <font color="#CC0000">删 除</font> ] </td>
</tr>
<?
mssql_field_seek($result_off,20);
for ($i;$i<=20;$i++)
{
$record_m=@mssql_fetch_object($result_off);
?>
<tr>
<td width="18%">
<? echo $record_m->com_id; ?>
</td>
<td width="46%"><a href="user_show.php?com_id=<? echo $record_m->com_id ?>">
<? echo $record_m->com_company; ?>
</a> </td>
<td width="16%">
<?
//取出订单状态
$sql_o="select * from order_info where order_com_id = '$record_m->com_id' order by order_id desc";
$result_o=@mssql_query($sql_o);
$record_o=@mssql_fetch_object($result_o);
$result_o_number=@mssql_num_rows($result_o);
if ($result_o_number==0)
{
echo "没有订单";
}
else
{
echo "<a href=\"order_show.php?order_id=".$record_o_->order_id."\">有".$result_o_number."单"; }
?>
</td>
<td width="20%">[ <font color="#CC0000"><a href="user.php?action=del&com_id=<? echo $record_m->com_id; ?>">删
除</a></font> ] </td>
</tr>
<?
}
?>
<tr>
<td colspan="4">
共有<font color="#CC0000"><? echo $page_number; ?></font>页/<font color="#CC0000">20</font>条/页
</td>
</tr>
for ($i;$i<=20;$i++)
$i是取过来的开始值,
我再重写一下吧刚才改的乱了
$sql_o="select * from order_info where order_com_id = '$record_m->com_id' order by order_id desc";
$result_o=@mssql_query($sql_o);
//delete one row
$result_o_number=@mssql_num_rows($result_o);
if ($result_o_number==0)
{
echo "没有订单";
}
else
{
//$offset 每页数目
mysql_data_seek($result_o,$offset);
$end=($offset+$page)>$num?$num:($offset+$page)-1;
for ($i=$offset;$i<=$end;$i++){
$row=mysql_fetch_row($result);
//$record_o=@mssql_fetch_object($result_o);
if ($i==$offset){
echo "<table><tr>";
//你的表头
echo "</tr><tr>";
}
for ($j=0;$j<sizeof($row);$j++)
echo "<td>".$row[$j]."</td>";
if ($i==$end)
echo "</tr><table>";
else
echo "</tr><tr>";
}
if ($offset!=0){
echo "<a href='".$path."0'>首页</a>";
echo "<a href='".$path.($offset-$page)."'>上一页</a>";
}
else
{
echo "首页";
echo "上一页";
}
if ($end<$num-1){ echo "<a href='".$path.($offset+$page)."'>下一页</a>";
echo "<a href='".$path.$num."'>尾页</a>";
}
else
{
echo "下一页";
echo "尾页";
}
echo "<br>";
for ($s=0;$s<$num;$s+=$page){
if ($s<10)
$zero="0";
else
$zero="";
if ($s==$offset)
echo " ".$zero.$s;
else
echo " [<a href='".$path.$s."'>".$zero.$s."</a>]";
}
}
?>