Break while loop inside for loop

Question

How can I break while loop and for loop too when while loop is true?

<?php
for($i=0; $i<4; $i++){
    $result = mysql_query("SELECT * FROM table WHERE weight='$i'");
    while($row = mysql_fetch_array($result)){
        echo $row['cell'];
        break; //I need to break the while loop and the for loop too in this line exactly, when he find and echo the "cell"!
    }
}
?>

Wouldn't specifying break 2; work? See: php.net/manual/en/control-structures.break.php — crcvd
– crcvd, Commented Jan 23, 2014 at 4:21
Why do you need the outer loop then? Why don't you just hardcode $i = 0; ? — zerkms
– zerkms, Commented Jan 23, 2014 at 4:21
Read the Docs.. break accepts an optional numeric argument which tells it how many nested enclosing structures are to be broken out of.... its in here:: php.net/manual/en/control-structures.break.php — Sudhir Bastakoti
– Sudhir Bastakoti, Commented Jan 23, 2014 at 4:21

zerkms · Accepted Answer · 2014-01-23 04:20:03Z

9

It is

break 2;

References:

http://php.net/break

...

answered Jan 23, 2014 at 4:20

zerkms

256k73 gold badges447 silver badges551 bronze badges

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

Comments

Nullpointer · Accepted Answer · 2014-01-23 04:21:07Z

1

Use Flags:

One flag inside while : Set this flag to 1 when you break while

One flag in outer for loop: If while loop flag is set then break for loop

answered Jan 23, 2014 at 4:21

Nullpointer

1,0867 silver badges22 bronze badges

Comments

Class · Accepted Answer · 2014-01-23 04:45:02Z

1

Instead of doing a break why not do the following

SELECT * FROM table WHERE weight BETWEEN 0 AND 3

OR just

SELECT * FROM table WHERE weight = 0

You would be limiting querying the database multiple times and probably takes less time but you'd wouldn't notice it with a query like this.

Not sure why you there is a for loop then break on first iteration when you can just query the database and echo something. Unless OP has other plans for this code and reduced the code for SO the loop is really unnecessary.

edited Jan 23, 2014 at 4:45

answered Jan 23, 2014 at 4:33

Class

3,1503 gold badges25 silver badges31 bronze badges

Comments

Deepu Sasidharan · Accepted Answer · 2014-01-23 04:23:49Z

0

use exit instead of break.

break results exit from current iteration while exit results exit from overall pgm.

answered Jan 23, 2014 at 4:23

Deepu Sasidharan

5,32911 gold badges46 silver badges100 bronze badges

3 Comments

zerkms Over a year ago

So why would OP prefer exit over break?

Deepu Sasidharan Over a year ago

in this case exit results exit from both while and for loop.

zerkms Over a year ago

it does. But it stops the whole application, which is not the case. At least it's not obvious that it's what OP wants

Collectives™ on Stack Overflow

Break while loop inside for loop

4 Answers 4

Comments

Comments

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related