你如何在while循环中有不同的表？ [英] How do you have different Tables in a while loop?
问题描述
Sup人。
好的，直截了当地说：我正在尝试使用数据库中的一些数据执行while循环，并且从数据显示的方式开始工作正常。我需要将数据显示在不同的< td>中。因为ID会有所不同，所以表格的结构如下：
______________
| TD 1 - 数据1 |
| TD 2 - 数据2 |
| TD 1 - 数据3 |
| TD 2 - 数据4 |
| TD 1 - 数据5 |
???????????
如果这对任何人都有意义lol。我是PHP和Mysql的新手，但对HTML和CSS没问题，所以如果我的PHP术语错误原谅我。到目前为止我的表格代码如下：
Sup guys.
Okay, straight to the point: I''m trying to perform a while loop with some data from my database and it''s working fine appart from the way the data is displayed. I need the data to be displayed in a different "<td>" as in the ID would be different, so that the structure of the table would look like this:
______________
| TD 1 - Data 1 |
| TD 2 - Data 2 |
| TD 1 - Data 3 |
| TD 2 - Data 4 |
| TD 1 - Data 5 |
???????????
If that makes any sense to anyone lol. I''m quite new to PHP and Mysql, but am okay with HTML and CSS, so if my PHP terms are wrong forgive me. My code for the table so far is as follows:
< table id =" navigation"标题= QUOT;导航"边界=" 0"宽度= QUOT; 190"对齐= QUOT;右" cellspacing =" 0">
< td rowspan =" 16" ID = QUOT; general_Sidebar" align =" right"> Hi< / td>
< td id =" general_Grey_Header" class =" general_Grey_Header">最新用户< br>< / td>
< / tr>
< ;?
$ dbres = mysql_query（" SELECT`invup`，`login` FROM`users` WHERE`level`！='' - 1''和'level`！=''0''和`game_id` =''1''ORDER BY`havup` DESC LIMIT 10"）;
while（$ user = mysql_fetch_assoc（$ dbres））{
？>
< tr>< td id =" general_Light_Grey" class =" general_Light_Grey">< b><？php echo（$ user [login]）; ？>< / b>< / td>
< / tr>
< tr>< td id =" general_Grey" ; class =" general_Grey">< b><？php echo（$ user [login]）; ？>< / b>< / td>
< / tr>
< ;?
}
？>
< / table>
<table id="navigation" title="Navigation" border="0" width="190" align="right" cellspacing="0">
<td rowspan="16" id="general_Sidebar" align="right">Hi</td>
<td id="general_Grey_Header" class="general_Grey_Header">Newest Users<br></td>
</tr>
<?
$dbres = mysql_query("SELECT `signup`,`login` FROM `users` WHERE `level`!=''-1'' AND `level`!=''0'' AND `game_id`=''1'' ORDER BY `signup` DESC LIMIT 10");
while($user = mysql_fetch_assoc($dbres)){
?>
<tr><td id="general_Light_Grey" class="general_Light_Grey"><b><?php echo($user[login]); ?></b></td>
</tr>
<tr><td id="general_Grey" class="general_Grey"><b><?php echo($user[login]); ?></b></td>
</tr>
<?
}
?>
</table>
这是最新用户功能，显示最近注册的十个用户名。到目前为止，我可以让它显示每个用户名两次，但具有正确的布局，或者显示每个名称一次，并且必须有错误的布局。我需要它来显示正确的布局并仅显示每个用户名一次。如果这也有任何意义lol。
如果需要更多信息，请询问，感谢您的时间和帮助：D
This is for a Newest User feature that displays the last ten usernames that signed up. So far I can either make it display each username twice but have the right layout, or disply each name once and have to wrong layout. I need it to display the right layout and display each username only once. If that also makes any sense lol.
If more info is required just ask, thanks for your time and help :D
推荐答案
dbres = mysql_query（" SELECT`invup`，`login` FROM`users` WHERE`level`！='' - 1''AND`level`！=''0''和`game_id` =' '1''订购'注册'DESC限制10"）;
while（
dbres = mysql_query("SELECT `signup`,`login` FROM `users` WHERE `level`!=''-1'' AND `level`!=''0'' AND `game_id`=''1'' ORDER BY `signup` DESC LIMIT 10");
while(
user = mysql_fetch_assoc（
user = mysql_fetch_assoc(
dbres））{
？>
< tr>< td id =" general_Light_Grey" class =" general_Light_Grey">< b><？php echo（
dbres)){
?>
<tr><td id="general_Light_Grey" class="general_Light_Grey"><b><?php echo(
这篇关于你如何在while循环中有不同的表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
