php loops mysql Help

Question

I am trying to make it stop showing the rest if $walk_jail is not empty

1) $walk_jail is empty

2) $walk_jail is empty

3) $walk_jail is empty

4) $walk_jail is Not empty

Stop showing the rest.

$walk = 15;

for ( $counter = 1; $counter <= $walk; $counter += 1) {

$result= mysql_query("SELECT * FROM walk_txt") or die (mysql_error());
$walk_numrows = mysql_num_rows($result);
$random_walk = rand(1,$walk_numrows);

$getfl = mysql_query("SELECT * FROM walk_txt WHERE id='$random_walk'");
$showfinfo = mysql_fetch_array($getfl);

$walk_txt = $showfinfo['txt'];
$walk_jail = $showfinfo['jail'];
$walk_hp = $showfinfo['hp'];
$walk_money = $showfinfo['money'];
$walk_item = $showfinfo['itemid'];

if($walk_jail){
echo "$counter) <span class='bad'>$walk_txt</span><br>";
}elseif($walk_money){
echo "$counter) <span class='win'>$walk_txt</span><br>";
}elseif($walk_item){
echo "$counter) <span class='win'>$walk_txt</span><br>";
}elseif($walk_money == 0 && $walk_jail == 0 && $walk_hp == 0){
echo "$counter) $walk_txt<br>";
}

Thank you

Michael Haren · Accepted Answer · 2009-11-01 02:35:38Z

1

I guess your looking for the break; statement, which will drop you out of a loop.

$walk = 15

for ( $counter = 1; $counter <= $walk; $counter += 1) {

  ....    

  if($walk_jail){
    echo "$counter) <span class='bad'>$walk_txt</span><br>";
    break; // ** this will drop out of the loop
  }elseif($walk_money){
    echo "$counter) <span class='win'>$walk_txt</span><br>";
  }elseif($walk_item){
    echo "$counter) <span class='win'>$walk_txt</span><br>";
  }elseif($walk_money == 0 && $walk_jail == 0 && $walk_hp == 0){
    echo "$counter) $walk_txt<br>";
  }
}

answered Nov 1, 2009 at 2:35

Michael Haren

109k41 gold badges172 silver badges208 bronze badges

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

1 Comment

James Brooks Over a year ago

You can also use break 1; etc to break out of various parts of the loop - just a little tip :)

Collectives™ on Stack Overflow

php loops mysql Help

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