我想在一行中显示两列从数据库提取出来的信息,不过我只能显示一行,加一个<td>就一行两列显示的数据是一样的 <?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
}
?>
$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
}
?>
<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>
$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
}
?>
大约是这样...你自己试试吧