PHP while loop not proceeding in the 2nd while loop

Question

I'm trying to fetch row so i can print it on my table. But the problem is that, the code only runs on the 1st while loop. After it fetch all the rows in the table, it stops there.

`Assuming that I have 5 rows in my tblUnit

while ($r = $q->fetch(PDO::FETCH_ASSOC)) {
    echo " <script type'text/javascript'> alert('1');</script>";
    $unitStatus = $r['unitStatus'];
    $unitNumber = $r['unitNumber'];
    $floorNumber = $r['floorCode'];
    $unitType = $r['unitType'];
    $t = $db->query("select floorLevel from tblFloors where floorID = $floorNumber");
    $w = $db->query("select unitTypeName from tblUnitType where unitTypeID = $unitType");
    while ($u = $t->fetch(PDO::FETCH_ASSOC)) {
        echo " <script type'text/javascript'> alert('2');</script>";
        $floorLevel = $u['floorLevel'];
        while ($x = $w->fetch(PDO::FETCH_ASSOC)) {
            echo " <script type'text/javascript'> alert('3');</script>";
            ....
            ...
            ..
        }
    }
}

The output(In alert box):

I'm using MS SQL Server for my database.

So many nested whiles .. are you sure, one query using JOIN wouldn't simplify this? — kero
– kero, Commented Mar 11, 2016 at 11:12

ScaisEdge · Accepted Answer · 2016-03-11 11:12:30Z

2

Could be a string evalueting problem try thsi way

$t = $db->query("select floorLevel from tblFloors where floorID = " .  $floorNumber .";");                              
$w = $db->query("select unitTypeName from tblUnitType where unitTypeID = " . $unitType . ";");

or

$t = $db->query("select floorLevel from tblFloors where floorID = '$floorNumber' ;");

Otherwise your $floorNumber don't contain the aspected result

answered Mar 11, 2016 at 11:12

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

juju17 Over a year ago

Thank you! In my database, there were no matching value for floorID recorded.

Collectives™ on Stack Overflow

PHP while loop not proceeding in the 2nd while loop

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related