Ben şu MySQL sorgu var:

<div class="box" id="settlement1">
        <?
            $query  = "SELECT name, pub, hospital, trade FROM settlements WHERE settlementID = 1";
            $result = mysql_query($query);

            while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
                $settlementName = $row['name'];
                $pubExists = $row['pub'];
                $hospitalExists = $row['hospital'];
                $tradeExists = $row['trade'];
            }
        ?>
        <div class="settlement-name"><? echo $settlementName; ?></div>
        <div class="settlement-contents">
            <?
                if ($hospitalExists == '1') { echo "<div class='hospital'>HOSPITAL</div>";  }
                if ($pubExists == '1') { echo "<div class='pub'>PUB</div>"; }
                if ($tradeExists == '1') { echo "<div class='trade'>TRADE</div>"; }
            ?>
        </div>
    </div>
    <div class="box" id="settlement2">
        <?
            $query  = "SELECT name, shop, hospital, trade FROM settlements WHERE settlementID = 2";
            $result = mysql_query($query);

            while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
                $settlementName = $row['name'];
                $pubExists = $row['pub'];
                $hospitalExists = $row['hospital'];
                $tradeExists = $row['trade'];
            }
        ?>
        <div class="settlement-name"><? echo $settlementName; ?></div>
        <div class="settlement-contents">
            <?
                if ($hospitalExists == '1') { echo "<div class='hospital'>HOSPITAL</div>";  }
                if ($pubExists == '1') { echo "<div class='pub'>PUB</div>"; }
                if ($tradeExists == '1') { echo "<div class='trade'>TRADE</div>"; }
            ?>
        </div>
    </div>

Şimdi, ilk sorgu çalışıyor, ancak ikinci ilk olarak aynı sonuçları verir.

ALL FIELDS ARE DIFFERENT IN QUERY 1 TO QUERY 2