21,886
社区成员
发帖
与我相关
我的任务
分享
$row = mysql_fetch_array($result);
while($row)
{
echo "<tr>";
for ($i=1; $i<=4; $i++)
{
echo "<td width='175px' height='150px' align='center'>";
echo "<a border=0 href='PRODUCT.php?id=" . $row['id'] ."'><img src='" . $row['face'] . "' border=0 height='105px' width='130px'/></a><br /><a border=0 href='PRODUCT.php?id=" . $row['id'] . "'>" . $row['name'] . "</a>";
echo "</td>";
$row = mysql_fetch_array($result);
}
echo "</tr>";
}
for ($i=1; $i<=4; $i++)
{
……
if($i<4)//加这一行
$row = mysql_fetch_array($result);
}
$q = "select * from fabrics_yarns"; //SQL查询语句
$result = mysql_query($q,$conn); //获取数据集
while($row = mysql_fetch_array($result))
{
echo "<tr>";
for ($i=1; $i<=4; $i++)
{
echo "<td width='175px' height='150px' align='center'>";
echo "<a border=0 href='PRODUCT.php?id=" . $row['id'] ."'><img src='" . $row['face'] . "' border=0 height='105px' width='130px'/></a><br /><a border=0 href='PRODUCT.php?id=" . $row['id'] . "'>" . $row['name'] . "</a>";
echo "</td>";
$row = mysql_fetch_array($result);
}
echo "</tr>";
}