读数据库技巧小谈(1)用移动X次记录指针预取来解决 每行显示X个记录,显示X行的方法(原创)

 未经允许不得转载.-----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>&nbsp; </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

}

?>