用while循环填充表


populate table with while loop

我试图填充一个表从我的MySQL数据库拉数据,在数据库中有3个条目,但由于某种原因,数据不工作,虽然我可以看到它通过循环3次(表创建3个复选框,每个条目1)

代码
<?php 
    $qry2="SELECT * FROM buytraff WHERE username='$username'";
    $result2=mysql_query($qry2) or die(mysql_error()); 
    while ($rows = mysql_fetch_assoc($result2)):?>
<tr class="first">
<td class="tc">&nbsp;</td>
<td class="tc"><center><font face="Arial, Helvetica, sans-serif"></font><font face="Arial, Helvetica, sans-serif"><? echo $rows['id']; ?></font>
</center></td>
<td class="tc"><center><font face="Arial, Helvetica, sans-serif"><? echo $rows['url']; ?></font></center></td>
<td><center><font face="Arial, Helvetica, sans-serif"><? echo $rows['nichecountry']; ?></font></center></td>
<td class="tc"><center><font face="Arial, Helvetica, sans-serif"><?php if($rows['type']=='1.99'){
echo "something";
}
elseif($rows['type']=='2.99'){
echo "something";
}
elseif($rows['type']=='3.00'){
echo "something";
}
elseif($rows['type']=='4.00'){
echo "something";
}
?></font></center></td>
<td class="tc"><center><font face="Arial, Helvetica, sans-serif"><? echo $rows['price']; ?> $</font></center></td>
<td class="tc"><center><font face="Arial, Helvetica, sans-serif"><? echo $rows['amount']; ?></font></center></td>
<td class="tc"><center><font face="Arial, Helvetica, sans-serif"><? echo $rows['delivered']; ?></font></center></td>
<td class="tc"><center><font face="Arial, Helvetica, sans-serif"><? echo $rows['status']; ?></font></center></td>
<td class="tc"><center><input name="checkbox[]" type="checkbox" class="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></center></td> 
</tr>
<?php endwhile; ?>

使用PHP短标签

在XAMPP中,您需要在PHP.ini中启用此选项:

short_open_tag = On