<?php
session_start();
include_once 'conn.php';
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3c.org/TR/1999/REC-html401-19991224/loose.dtd">
<HTML xmlns="http://www.w3.org/1999/xhtml"><HEAD>
<TITLE>化妆品销售网站</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<LINK href="qtimages/style.css" type=text/css rel=stylesheet>
<META content="MSHTML 6.00.2900.6058" name=GENERATOR>
</HEAD>
<BODY>
<?php include_once 'qttop.php';?>
<TABLE cellSpacing=0 cellPadding=0 width=1120 align=center bgColor=#ffffff
border=0>
<TBODY>
<TR>
<TD width=5> </TD>
<TD vAlign=top width=230>
<?php include_once 'qtleft.php';?>
</TD>
<TD vAlign=top width=10> </TD>
<TD vAlign=top>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD vAlign=bottom height=40>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD width=58 height=40><IMG height=35
src="qtimages/B0039.gif"
width=30></TD>
<TD width=14> </TD>
<TD width=278><span class="red"><strong>在线留言</strong></span></TD>
<TD vAlign=bottom align=right width=66></TD>
<TD vAlign=bottom align=right width=354> </TD>
<TD width=97 align=left ><strong><a href="lyb.php"><font class="red">我要留言</font></a></strong></TD>
</TR>
</TBODY></TABLE></TD></TR>
<TR>
<TD bgColor=#dadada height=1></TD></TR>
<TR>
<TD bgColor=#f6f6f6 height=4></TD></TR>
<TR>
<TD bgColor=#ffffff height=6><table width="100%" border="1" align="center" cellpadding="3" cellspacing="1" bordercolor="#ADCEEF" style="border-collapse:collapse">
<?php
$sql="select * from liuyanban where 1=1";
$sql=$sql." order by id desc";
$query=mysql_query($sql);
$rowscount=mysql_num_rows($query);
if($rowscount==0)
{}
else
{
$pagelarge=5;//每页行数;
$pagecurrent=$_GET["pagecurrent"];
if($rowscount%$pagelarge==0)
{
$pagecount=$rowscount/$pagelarge;
}
else
{
$pagecount=intval($rowscount/$pagelarge)+1;
}
if($pagecurrent=="" || $pagecurrent<=0)
{
$pagecurrent=1;
}
if($pagecurrent>$pagecount)
{
$pagecurrent=$pagecount;
}
$ddddd=$pagecurrent*$pagelarge;
if($pagecurrent==$pagecount)
{
if($rowscount%$pagelarge==0)
{
$ddddd=$pagecurrent*$pagelarge;
}
else
{
$ddddd=$pagecurrent*$pagelarge-$pagelarge+$rowscount%$pagelarge;
}
}
for($i=$pagecurrent*$pagelarge-$pagelarge;$i<$ddddd;$i++)
{
?>
<tr>
<td width="11" rowspan="3" valign="top"><!--DWLayoutEmptyCell--> </td>
<td width="85" rowspan="3" align="center" valign="middle"><img width='70'height='70' src=<?php echo mysql_result($query,$i,"zhaopian");?> border=0> </td>
<td height="20" colspan="2" align="left" valign="middle"> 留言于:<?php echo mysql_result($query,$i,"addtime");?> </td>
<td width="12" rowspan="3" valign="top" style=" 10px"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td height="78" align="left" valign="top"> <?php echo mysql_result($query,$i,"liuyan");?></td>
<td align="left" valign="top"><p>回复:</p>
<p><?php echo mysql_result($query,$i,"huifu");?></p></td>
</tr>
<tr>
<td colspan="2" align="left" valign="middle" style="height: 25px"> 账号:<?php echo mysql_result($query,$i,"zhanghao");?> 姓名:<?php echo mysql_result($query,$i,"xingming");?> </td>
</tr>
<?php
}
}
?>
</table>
<p align="center"><a href="lyblist.php?pagecurrent=1">首页</a>, <a href="lyblist.php?pagecurrent=<?php echo $pagecurrent-1;?>">前一页</a> ,<a href="lyblist.php?pagecurrent=<?php echo $pagecurrent+1;?>">后一页</a>, <a href="lyblist.php?pagecurrent=<?php echo $pagecount;?>">末页</a>, 当前第<?php echo $pagecurrent;?>页,共<?php echo $pagecount;?>页 以上数据共
<?php
echo $rowscount;
?>
条,
<input type="button" name="Submit2" onClick="javascript:window.print();" value="打印本页" style=" height:19px; border:solid 1px #000000; color:#666666" />
</p></TD>
</TR></TBODY></TABLE>
</TD>
<TD width=5> </TD></TR></TBODY></TABLE>
<?php include_once 'qtdown.php';?></BODY></HTML>