21,887
社区成员
发帖
与我相关
我的任务
分享
<?php
$sql="SELECT * FROM books WHERE prize<10 limit 2,6";
mysql_query("SET NAMES GBK");
$res2=mysql_query($sql);
while($row2=mysql_fetch_array($res2))
{
?>
<tr>
<td align="center">
<table>
<tr><td><img src="image/<?=$row2['image']?>" height="90" width="70"/></td></tr>
<tr><td>书名:<?=$row2['Name']?></td></tr>
<tr><td>价格:¥<?=$row2['prize']?></td></tr>
</table>
</td>
<td align="center">
<table>
<tr><td><img src="image/<?=$row2['image']?>" height="90" width="70"/></td></tr>
<tr><td>书名:<?=$row2['Name']?></td></tr>
<tr><td>价格:¥<?=$row2['prize']?></td></tr>
</table>
</td>
</tr>
<?php
}
?>
<?php
$sql="SELECT * FROM books WHERE prize<10 limit 2,6";
mysql_query("SET NAMES GBK");
$res2=mysql_query($sql);
while($row2=mysql_fetch_assoc($res2))
{
?>
<tr>
<td align="center">
<table>
<tr><td><img src="image/<?=$row2['image']?>" height="90" width="70"/></td></tr>
<tr><td>书名:<?=$row2['Name']?></td></tr>
<tr><td>价格:¥<?=$row2['prize']?></td></tr>
</table>
</td>
<td align="center">
<?php if ($row2 = mysql_fetch_assoc($res2)) { ?>
<table>
<tr><td><img src="image/<?=$row2['image']?>" height="90" width="70"/></td></tr>
<tr><td>书名:<?=$row2['Name']?></td></tr>
<tr><td>价格:¥<?=$row2['prize']?></td></tr>
</table>
<?php } else {echo ' ';} ?>
</td>
</tr>
<?php
}
?>
<table>
<?php
$sql="SELECT * FROM books WHERE prize<10 limit 2,6";
mysql_query("SET NAMES GBK");
$res2=mysql_query($sql);
while($row2=mysql_fetch_array($res2))
{ //循环一次产生一行<tr>...</tr>
?>
<tr> <!-- 每行有三列<td>..</td>-->
<td><img src="image/<?=$row2['image']?>" height="90" width="70"/></td>
<td>书名:<?=$row2['Name']?></td>
<td>价格:¥<?=$row2['prize']?></td>
</tr>
<?php
}
?>
</table>