<?
//-----------[基本设定]-------------
$mysql_server_name = "localhost";
$mysql_username = "root";
$mysql_password = "stream";
$mysql_database = "123321";
//-----------[建立连接]-------------
//准备好SQL语法
$sql="SELECT id, name, sex, email, info, ip, date_format(time_at,'%Y年月 %m月 %d日 %T') FROM `gbook` ORDER BY `id` DESC";
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
$result=mysql_db_query($mysql_database,$sql,$conn);
while($row=mysql_fetch_row($result))
{
//print_r($row);
if($row[2]==1)
{
$gender ='小帅哥';
}
else
{
$gender ='大美女';
}
?>
<table width="980" border="1">
<tr>
<td width="978" height="31"><p>|<?=$row[0]?>|<?=$row[6]?> (<?=$row[5]?>)</p>
<p><?=$row[1]?><?=$gender?><<a href="mailto:<?=$row[3]?>"><?=$row[3]?></a>>写道:</p></td>
</tr>
<tr>
<td height="53"><?=nl2br($row[4])?><br>[<a href="del.php?id=<?=$row[0]?>">删除</a>] [<a href="modify.php?id=<?=$row[0]?>">修改</a>]</td>
</tr>
</table>
<hr>
<?
}
mysql_free_result($result);
?>
以上是小弟写的留言程序,求个分页代码,在线等大师帮忙... |