楼主是不是想横向排列输出啊?给个建议,你把html元素也写进php代码,然后用一个变量来控制换行,如:
$i=3;
while($row = $db->fetch_array($query)) {
if($i%3==0)
echo "<tr>";
........
$i++;
if($i%3==0)
echo "</tr>";
}
$i=3;
while($row = $db->fetch_array($query)) {
if($i%3==0)
echo "<tr>";
........
$i++;
if($i%3==0)
echo "</tr>";
}
<?
$sql = "select * from pic";
// echo $sql;
$query = $db->query($sql);
$i=3;
while($row = $db->fetch_array($query)) {
if($i%3==0)
echo "<tr>";
?>
<tr>
<td colspan="2"> <img src="<? echo "upload_images/".$row["pic"]?>">
</td>
</tr>
<tr>
<td width="29%">说明: </td>
<td width="71%" rowspan="2"><input type="submit" name="Submit2" value="提交"></td>
</tr>
<tr>
<td>查看:</td>
<?
$i++;
if($i%3==0)
echo "</tr>";
}
?>
</table>
</form>
<? }?>
</td>
</tr>
</table>
while($row = $db->fetch_array($query)) {
if($i%3==0)
echo "<tr>";
........(这里是你想横向排列的数据显示)
$i++;
if($i%3==0)
echo "</tr>";
}
echo "<table width=30% border=0 cellspacing=0 cellpadding=2>";
$sql = "select * from pic";
// echo $sql;
$query = $db->query($sql);
$i=3;
while($row = $db->fetch_array($query)) {
if($i%3==0)
echo "<tr>";
echo "<td colspan=2><img src=\"upload_images/\"".$row["pic"].">";
echo "</td>";
$i++;
if($i%3==0)
echo "</tr>";
}
echo "</table>";
?>具体你再根据你的需要改了
<table width="30%" border="0" cellspacing="0" cellpadding="2">
<?
$sql = "select * from pic";
$query = $db->query($sql);
$i=3;
while($row = $db->fetch_array($query)) {
if($i%3==0)
echo "<tr>";
?>
<td colspan="2"><img src="<? echo "manage/upload_images/".$row["pic"]?>">
</td>
<tr><td width="9%">说明: </td>
<td width="91%" rowspan="2"><input type="submit" name="Submit" value="兑奖"></td>
</tr>
<tr>
<td>查看:</td>
<?
$i++;
if($i%3==0)
echo "</tr>";
}
echo "</table>";
?>
你这样改肯定不行啦!只要是你表格的排版问题!<?
echo "<table width=30% border=0 cellspacing=0 cellpadding=2>";
$sql = "select * from pic";
// echo $sql;
$query = $db->query($sql);
$i=3;
while($row = $db->fetch_array($query)) {
if($i%3==0)
echo "<tr>";
echo "<td colspan=2>";
echo "<table width=100% border=0 cellspacing=0 cellpadding=2>";
echo "<tr><td colspan=2><img src=upload_images/".$row["pic"]."></td></tr>";
echo "<tr><td width=29%>说明:</td><td width=71% rowspan=2>";
echo "<input type=submit name=Submit2 value=提交></td></tr>";
echo "<tr><td>查看:</td>";
echo "</table>";
echo "</td>";
$i++;
if($i%3==0)
echo "</tr>";
}
echo "</table>";
?>试试吧。