未经允许不得转载.-----InberKong
数据库技巧小谈(1)用移动记录指针来解决 每行显示X个记录,显示X行的方法.
有我们的实际应用中常会遇到这样的问题,比如你在做有一个电子商务的产品管理系统,在显示产品时要显示X行,X列的产品,
用移动多条记录指针来解决 每行显示X个记录,显示X行的方法.
以下为一人才展示系统(每行显示三条)
<?php
//开始读取数据库
$query=mysql_query("SELECT * FROM rc_fkiori_youxiu ORDER BY date desc limit $pagedb,$fkioriperpage");
while($resultsql1=mysql_fetch_array($query))
{
//每行3条
$resultsql2=mysql_fetch_array($query);
$resultsql3=mysql_fetch_array($query);
//
?>
<table width="750" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#F5F5F5" class="html">
<tr>
<td> </td>
</tr>
</table>
<table width="750" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#F5F5F5" class="html">
<tr>
<td width=250>
<!-- the first start -->
<table width="210" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><img src="<?php echo $resultsql1[other1]; ?>" width="70" height="91" border="1"></td>
<td width="187">
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="0" class="v">
<tr class="v">
<td width="8%" height="20"> <div align="center"></div></td>
<td width="31%" height="20"> 姓名:</td>
<td width="61%" height="20"><?php echo $resultsql1[name]; ?></td>
</tr>
<tr class="v">
<td height="20"> <div align="center"></div></td>
<td height="20"> 专业:</td>
<td height="20"><?php echo $resultsql1[zhuanye]; ?></td>
</tr>
<tr class="v">
<td height="20"> <div align="center"></div></td>
<td height="20"> 学校:</td>
<td height="20"><?php echo $resultsql1[school]; ?></td>
</tr>
<tr class="v">
<td height="20" colspan="3"><div align="center"></div></td>
</tr>
</table>
</td>
</tr>
</table>
<!-- the first end -->
</td>
<td width=250>
<?php if($resultsql2){
?>
<!--the second start-->
<table width="210" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><img src="<?php echo $resultsql2[other1]; ?>" width="70" height="91" border="1"></td>
<td width="187"><table width="95%" border="0" align="center" cellpadding="0" cellspacing="0" class="v">
<tr class="v">
<td width="8%" height="20"> <div align="center"></div></td>
<td width="30%" height="20"> 姓名:</td>
<td width="62%" height="20"><?php echo $resultsql2[name]; ?></td>
</tr>
<tr class="v">
<td height="20"> <div align="center"></div></td>
<td height="20"> 专业:</td>
<td height="20"><?php echo $resultsql2[zhuanye]; ?></td>
</tr>
<tr class="v">
<td height="20"> <div align="center"></div></td>
<td height="20"> 学校:</td>
<td height="20"><?php echo $resultsql2[school]; ?></td>
</tr>
<tr class="v">
<td height="20" colspan="3"><div align="center"></div></td>
</tr>
</table></td>
</tr>
</table>
<!--the second end-->
<?php } ?>
</td>
<td width=250>
<?php if($resultsql3){
?>
<!--the third start-->
<table width="210" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><img src="<?php echo $resultsql3[other1]; ?>" width="70" height="91" border="1"></td>
<td width="187"><table width="95%" border="0" align="center" cellpadding="0" cellspacing="0" class="v">
<tr class="v">
<td width="13%" height="20"> <div align="center"></div></td>
<td width="31%" height="20"> 姓名:</td>
<td width="56%" height="20"><?php echo $resultsql3[name]; ?></td>
</tr>
<tr class="v">
<td height="20"> <div align="center"></div></td>
<td height="20"> 专业:</td>
<td height="20"><?php echo $resultsql3[zhuanye]; ?></td>
</tr>
<tr class="v">
<td height="20"> <div align="center"></div></td>
<td height="20"> 学校:</td>
<td height="20"><?php echo $resultsql3[school]; ?></td>
</tr>
<tr class="v">
<td height="20" colspan="3"><div align="center"> <br>
</div></td>
</tr>
</table></td>
</tr>
</table>
<!--the third end -->
<?php } ?>
</td>
</tr>
</table>
<?php
}
?>