While loop is not displaying all values

Question

I am having this weird problem. There are seven admins: darth, jane, luke, najin, root, sam and sydney.

CODE:

    <table>
          <tr>
            <th style="text-align: left; width: 200px;">Username</th>
            <th colspan="2" style="text-align: left;">Action</th>
          </tr>
        <?php 

            $sql = "SELECT * FROM admins ORDER BY Admin_Username ASC";
            $result = mysqli_query($connection, $sql);
            $admin = mysqli_fetch_assoc($result);

            while($admin = mysqli_fetch_assoc($result)) { 
            ?>
          <tr>
            <td><?php echo ($admin["Admin_Username"]); ?></td>
            <td><a href="edit_admin.php?id=<?php echo urlencode($admin["id"]); ?>">Edit</a></td>
            <td><a href="delete_admin.php?id=<?php echo urlencode($admin["id"]); ?>" onclick="return confirm('Are you sure you want to delete this admin?');">Delete</a></td>
          </tr>
        <?php     
} 
?>
</table>

If I use ASC order, the first admin, darth is not displayed in the loop and if I use DESC order, the last admin, sydney doesn't show up. What could be the problem here?

Amber · Accepted Answer · 2014-11-02 07:31:02Z

4

Get rid of the first $admin = line.

Your loop will fetch all of them; you don't need to fetch the first one separately (and if fact by doing so are skipping it, because your loop immediately fetches the second before the first one could be written out).

answered Nov 2, 2014 at 7:31

Amber

531k89 gold badges643 silver badges558 bronze badges

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

Comments

arif_suhail_123 · Accepted Answer · 2014-11-02 07:31:37Z

3

remove this line

 $admin = mysqli_fetch_assoc($result);//You already fetching the first result here

answered Nov 2, 2014 at 7:31

arif_suhail_123

2,5092 gold badges14 silver badges16 bronze badges

Comments

Mureinik · Accepted Answer · 2014-11-02 07:32:29Z

2

You have a redundant call to $admin = mysqli_fetch_assoc($result); before the while loop which will cause you to skip the first row of the result. Just remove it and you should be fine.

answered Nov 2, 2014 at 7:32

Mureinik

316k54 gold badges399 silver badges405 bronze badges

Comments

deviloper · Accepted Answer · 2014-11-02 07:33:42Z

2

    <?php 

            $sql = "SELECT * FROM admins ORDER BY Admin_Username ASC";
            $result = mysqli_query($connection, $sql);    
            while($admin = mysqli_fetch_assoc($result)) { 
            ?>
          <tr>
            <td><?php echo ($admin["Admin_Username"]); ?></td>
            <td><a href="edit_admin.php?id=<?php echo urlencode($admin["id"]); ?>">Edit</a></td>
            <td><a href="delete_admin.php?id=<?php echo urlencode($admin["id"]); ?>" onclick="return confirm('Are you sure you want to delete this admin?');">Delete</a></td>
          </tr>
    <?php     
    } 
    ?>

answered Nov 2, 2014 at 7:33

deviloper

7,25210 gold badges52 silver badges79 bronze badges

Comments

Pratik Joshi · Accepted Answer · 2014-11-03 09:21:06Z

0

$admin = mysqli_fetch_assoc($result);

This must be in while loop So you can descard/remove old value above while

answered Nov 3, 2014 at 9:21

Pratik Joshi

11.7k7 gold badges44 silver badges73 bronze badges

Collectives™ on Stack Overflow

While loop is not displaying all values

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