Using a Loop counter with While

Question

I have a query that selects all the users from my table. Then my while loop loops through it. If the current user is friends with the user in the queried row the row of data is skipped, if not, then the row is displayed. How can I make this while loop stop after 3 successful rows are display? Just to be clear, not just 3 rows can be queried.

Here is my code:

                $query_know="SELECT * FROM users ORDER BY RAND()";
                $result_know= mysqli_query($connect, $query_know);
                $i= 0;
                    while ($row_know= mysqli_fetch_array($result_know)) {
                        $query_friend_test= "SELECT * FROM relations WHERE user1= '".$user_id."' AND user2= '".$row_know['user_id']."'";
                        $result_friend_test= mysqli_query($connect, $query_friend_test);
                            if (mysqli_num_rows($result_friend_test) > 0) {
                                continue;
                            }
                            else {
            ?>

            <div class="user-mini">
                <div class="user-mini-left">
                </div>
                <div class="user-mini-right">
                        <div class="story-user-mini">
                            <p><a href="<?php echo "profile.php?id=" . $row_know['user_id']; ?>"> <?php echo $row_know['fname'] . " " . $row_know['lname']; ?> </a></p>
                        </div>
                        <div class="story-content-mini">
                            <p> Ohio University </p>
                        </div>
                </div>
            </div>

            <?php
            }
            }

            ?>

Sammi De Guzman · Accepted Answer · 2012-09-22 00:56:12Z

1

For whatever $n number of rows you want to display:

for($i = 0; $i < $n; $i++) {
    $row_know = mysqli_fetch_array($result_know);

    ... rest of code ...

}

When putting it in a for loop, it means you're doing it only from $i = 0 to $i < $n, and when you use a while loop, you're doing it forever, that is until you issue a break statement somewhere. If the number of rows is definite, you can use for.

EDIT: I meant to say for, not foreach.

answered Sep 22, 2012 at 0:56

Sammi De Guzman

5679 silver badges20 bronze badges

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

Comments

Moak · Accepted Answer · 2012-09-22 00:54:14Z

0

You can use break to exit a while loop.

answered Sep 22, 2012 at 0:54

Moak

12.9k27 gold badges117 silver badges168 bronze badges

Comments

Teena Thomas · Accepted Answer · 2012-09-22 00:58:20Z

0

do this condition check in the else part and an increment of $i++ inside the else {}

  else if($i <=2) {

        ?>

        <div class="user-mini">
            <div class="user-mini-left">
            </div>
            <div class="user-mini-right">
                    <div class="story-user-mini">
                        <p><a href="<?php echo "profile.php?id=" . $row_know['user_id']; ?>"> <?php echo $row_know['fname'] . " " . $row_know['lname']; ?> </a></p>
                    </div>
                    <div class="story-content-mini">
                        <p> Ohio University </p>
                    </div>
            </div>
        </div>
       <?php  $i++;
        }
        }

answered Sep 22, 2012 at 0:58

Teena Thomas

5,2091 gold badge15 silver badges17 bronze badges

Collectives™ on Stack Overflow

Using a Loop counter with While

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related