Using an If statement in a While loop PHP

Question

Trying to test which row the loop is on and if it's greater than or equal to six, plug the $TESTIMAGE variable into the span element for the next iteration.

When I run the code, it plugs the variable into everything following the first row.

While($row = mysql_fetch_array($result))

{

    //assign variables
    $title = $row['title'];
    $url = $row['location'];
    $image = "/waves/files/images/games/$title.png";

    echo "
            <span class='dropt'>

                <a href=$url>$title</a>

                        <span class='$TESTIMAGE'>
                            <img src='$image'>
                        </span>

            </span>
            <br />
    ";



//Test to see which row we're on -- adjust image position
If (mysql_num_rows($result) >= 6)
{
$TESTIMAGE = "image_display_up";
}   



}

So what you're saying is that you'd like that add something to the markup if it's row number 7 ? — adeneo
– adeneo, Commented Dec 11, 2012 at 0:40

Justin McDonald · Accepted Answer · 2012-12-11 00:41:08Z

2

use an increasing index:

$i = 0;
while($row = mysql_fetch_array($result)){
    $i += 1;
}

answered Dec 11, 2012 at 0:41

Justin McDonald

2,16616 silver badges19 bronze badges

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

Comments

Mike Brant · Accepted Answer · 2012-12-11 00:42:04Z

0

That is because mysql_num_rows() will return the same exact value for each iteration of the loop, as the number of rows in the result change will not change.

You would need to implement a counter to do what you are wanting to do.

answered Dec 11, 2012 at 0:42

Mike Brant

71.4k10 gold badges102 silver badges104 bronze badges

Comments

MAXIM · Accepted Answer · 2012-12-11 00:42:49Z

0

try it like this:

$i = 1;

While($row = mysql_fetch_array($result)) {
    if(!($i%6)) {  // will enter here on the 6th try.

    //assign variables
    $title = $row['title'];
    $url = $row['location'];
    $image = "/waves/files/images/games/$title.png";

        echo "
        <span class='dropt'>

            <a href=$url>$title</a>

                    <span class='$TESTIMAGE'>
                        <img src='$image'>
                    </span>

            </span>
            <br />
       ";
  }
  if($i!=6)  // this way it remains on 6
     $i++;

}

answered Dec 11, 2012 at 0:42

MAXIM

1,2311 gold badge9 silver badges16 bronze badges

Comments

adeneo · Accepted Answer · 2012-12-11 00:43:29Z

0

$i=0;
While($row = mysql_fetch_array($result)) {
    //assign variables
    $title = $row['title'];
    $url = $row['location'];
    $image = "/waves/files/images/games/$title.png";
    $TESTIMAGE = ($i++ >= 6) ? "image_display_up" : "";

    echo "
            <span class='dropt'>
                <a href=$url>$title</a>
                        <span class='$TESTIMAGE'>
                            <img src='$image'>
                        </span>
            </span>
            <br />
    ";
}

answered Dec 11, 2012 at 0:43

adeneo

319k29 gold badges410 silver badges392 bronze badges

Comments

Matthew Smith · Accepted Answer · 2012-12-11 00:43:32Z

0

The call to mysql_num_rows($result) always returns the same number. You want to increment an index on each iteration instead:

$idx = 0
while (blah) {
    if ($idx >= 6)
    {
        $TESTIMAGE = "image_display_up";
    }   
    $idx += 1
}

answered Dec 11, 2012 at 0:43

Matthew Smith

6,2856 gold badges38 silver badges36 bronze badges

Collectives™ on Stack Overflow

Using an If statement in a While loop PHP

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related