can't get the logic to restart looping

Question

I have 15 databases 1,2,3,4, ... 15
and I have the variable $i default at 1 and each time the $i count gets to 3, $i restarts the looping from 1 again until 3 and it will stop until value from database is done counting.

$detailPsycho = mysql_query("SELECT * FROM `psycho` WHERE `flag` = 2 ") or die(mysql_error());

        while($detail = mysql_fetch_array($detailPsycho)){



    for($i = 1;$i<=3;$i++){ 

        echo $detail['sequence']."&".$i." <br>";

    }

        }

and run over like this :/

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

Answer 1

You try to do a loop (for{}) in a loop (while{}) which is a complicated way of doing something trivial. This is the "while+for" result :

$detailPsycho = mysql_query("SELECT * FROM `psycho` WHERE `flag` = 2 ") or die(mysql_error());

i = (int) 1;
while($detail = mysql_fetch_array($detailPsycho)) {

    echo $detail['sequence']."&".$i." <br>";
    $i++;
    if ($i > 3) $i = 1;
}

can't get the logic to restart looping

Sign up