为什么它不能防止进一步的循环呢？

Question

我的代码似乎在6次和2次迭代后没有停止-为什么会这样？我不希望显示超过6个来自服务的值，以及2个来自文化的值。

ECHO "<fieldset>Services: ";
$servicearray = mysql_query("select serv_id from org_serv_xref where org_id='".$org_id."'");
while ($servicearrayrow = mysql_fetch_array($servicearray)) {
    $servdescarray = mysql_query("select serv_desc from service where serv_id='".$servicearrayrow['serv_id']."'");
    $i = 0;
    while ($servdescarrayrow = mysql_fetch_array($servdescarray)) {
        if ($i < 6) {
            ECHO $servdescarrayrow['serv_desc']." ";
            $i++;
        }
        else {
            break;
        }
    }
}
ECHO "</fieldset>";
ECHO "<fieldset>Cultures: ";
$culturearray = mysql_query("select cult_id from org_cult_xref where org_id='".$org_id."'");
while ($culturearrayrow = mysql_fetch_array($culturearray)) {
    $cultdescarray = mysql_query("select cult_desc from culture where cult_id='".$culturearrayrow['cult_id']."'");
    $i = 0;
    while ($cultdescarrayrow = mysql_fetch_array($cultdescarray)) {
        if ($i < 2) {
            ECHO $cultdescarrayrow['cult_desc']." ";
            $i++;
        }
        else {
            break;
        }
    }
}
ECHO "</fieldset>";

Answer 1

使用break 2而不是break，break 2退出2级循环。

看一看doc。

您还可以在sql语句中使用LIMIT 6。

Answer 2

你在循环内外一遍又一遍地同一个变量，这把事情搞乱了：

while ($servicearrayrow = mysql_fetch_array($servicearray)) {
    $servdescarray = mysql_query("select serv_desc from service where serv_id='".$servicearrayrow['serv_id']."'");

    $i = 0;
    while ($servdescarrayrow = mysql_fetch_array($servdescarray)) { //<<WHA??