如何在While语句中运行While语句以从数据库中获取值?
|
这是我的功能:
$result_display = mysql_query(\"SELECT * FROM Events ORDER BY TimeStamp DESC LIMIT $y, 20\");
$result_comment = mysql_query(\"SELECT * FROM Comments\");
while($row_display = mysql_fetch_array($result_display)){
echo \"<div id=\'id\'\" . $row_display[\'ID\'] . \" class=\'eventdiv\' data-sort=\'\".$row_display[\'TimeStamp\'].\"\'>\".$row_display[\'Title\'].\" TIME: \".$row_display[\'TimeStamp\'].\"</div>\";
while($row_comment = mysql_fetch_array($result_comment)){
echo $row_comment[\'com_details\'];
}
}
HTML输出类似于以下内容:
<div id=\'id12\' class=\'eventdiv\' data-sort=\'238781>Time: 238781</div>
<div id=\'id13\' class=\'eventdiv\' data-sort=\'238784>Time: 238784</div>
<div id=\'id14\' class=\'eventdiv\' data-sort=\'238785>Time: 238785</div>
<div id=\'id15\' class=\'eventdiv\' data-sort=\'238789>Time: 238789</div>
<div id=\'id16\' class=\'eventdiv\' data-sort=\'238791>Time: 238791</div>
<div id=\'id17\' class=\'eventdiv\' data-sort=\'238795>Time: 238795</div>
These are the comment details...
但我希望输出是这样的:
<div id=\'id12\' class=\'eventdiv\' data-sort=\'238781>Time: 238781</div>
These are the comment details...
<div id=\'id13\' class=\'eventdiv\' data-sort=\'238784>Time: 238784</div>
These are the comment details...
<div id=\'id14\' class=\'eventdiv\' data-sort=\'238785>Time: 238785</div>
These are the comment details...
<div id=\'id15\' class=\'eventdiv\' data-sort=\'238789>Time: 238789</div>
These are the comment details...
<div id=\'id16\' class=\'eventdiv\' data-sort=\'238791>Time: 238791</div>
These are the comment details...
<div id=\'id17\' class=\'eventdiv\' data-sort=\'238795>Time: 238795</div>
These are the comment details...
我以为我在while语句中有一个while语句的方式会像上面的HTML一样显示它,但事实并非如此。
没有找到相关结果
已邀请:
3 个回复
邵酮
重置它。所以:
物崎巩
殿虫
我发现了为什么它不起作用,第二个提取函数需要放在第一个while语句中。否则,它将在完成后立即执行:
很简单。