修改 while($rs=mysql_fetch_object($result))下面的那段,改的比较多我估计得。
加一个自增加行在while和判断在while循环中。是偶数就加<tr><td>……</td>,是奇数就加<td></td></tr>。然后在最后加table标签。思路就是这样。
加一个自增加行在while和判断在while循环中。是偶数就加<tr><td>……</td>,是奇数就加<td></td></tr>。然后在最后加table标签。思路就是这样。
echo "<tr>";
while($rs=mysql_fetch_object($result)){
$i++;
if($i>0&&i%2==0)
echo "</tr><tr>";echo "<td>记录</td>";}echo "</tr>";这只是一个思路,可以参考
循环里,在第二个记录前用
if($rs=mysql_fetch_object($result)){
echo "<td>记录<td>";
}
<?
require_once('config.php');
$exec="select * from products where b_class='1'";
$result=mysql_query($exec); $recountCount = mysql_num_rows($result);
$totalPage = ceil($recountCount/10);
$page = (isset($page) && $page>=0)? $page: 0;
$isLast = ($page==($totalPage-1))? true: false;
$hasNoPre = ($page==0)? true: false;
$hasNoNext = ($page==$totalPage-1)? true: false;
$isFirst = ($page==0)? true:false; $exec="select * from products where b_class='1' order by id desc limit ".($page*10).",10";//一页是10记录的
$result=mysql_query($exec);
$i=0;
echo "<tr>";
while($rs=mysql_fetch_object($result))
{
?>
<td width=26%><img border=0 src=$rs->s_image width=100 height=100></td>
<td width=23% rowspan=2 valign=top>
<table border=0 width=100% cellspacing=1>
<tr>
<td width=42% valign=top>品号:</td>
<td width=58% valign=top>$rs->number</td>
</tr>
<tr>
<td width=42% valign=top>品名:</td>
<td width=58% valign=top>$rs->name</td>
</tr>
<tr>
<td width=42% valign=top>价格:</td>
<td width=58% valign=top>$rs->price</td>
</tr>
</table>
</td>
<?
if($i>0&&i%2==0) echo "</tr><tr>";} ?>
</tr>
</table>
<table>
<tr><td colspan="4" align="right">
<?
$str = "共 $recountCount 条记录,当前第 ".($page+1)."/$totalPage 页 ";
$str .= $isFirst? "首页 " : "<a href=\"jjsh.php?page=0\">首页</a> ";
$str .= $hasNoPre? "上一页 " : "<a href=\"jjsh.php?page=".($page-1)."\">上一页</a> ";
$str .= $hasNoNext? "下一页 " : "<a href=\"jjsh.php?page=".($page+1)."\">下一页</a> ";
$str .= $isLast? "尾页 " : "<a href=\"jjsh.php?page=".($totalPage-1)."\">尾页</a>";
echo $str;
?>
</td></tr>
</table>可能删了一些不明白的东西,中间有的PHP变量没改过来。