cannot reset query row after executing while loop

Question

Hi whenever I try to reset row so that I can use same rows for a new column I get error: reset() expects parameter 1 to be array

I am new to PHP and was trying to build a table that outputs data stored in MySQL:

<?php

include ('config.php');

$user = mysqli_query($userDB, "SELECT username, email FROM user") or die(mysqli_error());

?>
 <table width="200" border="1">
  <tbody>
    <tr>
      <th scope="col">Username</th>
      <th scope="col">Email</th>
    </tr>
    <tr>
    <td align = "center">
    <?php while($row = mysqli_fetch_assoc($user)) echo $row["username"]."<br>"; reset($row); ?>
    </td>
    <td align = "center">
    <?php while($row = mysqli_fetch_assoc($user)) echo $row["email"]."<br>" ?>
    </td>
    </tr>
  </tbody>
</table>

Any better way I can do this?

You really want a list of usernames in a single <td> and a list of emails in the other? — Don't Panic
– Don't Panic, Commented May 15, 2018 at 22:05
Why are you doing reset() on the username? If you want to display the list per row then you're doing it wrong. — hungrykoala
– hungrykoala, Commented May 16, 2018 at 0:15

Felippe Duarte · Accepted Answer · 2018-05-15 22:06:07Z

1

You can rewrite in a better way:

<table width="200" border="1">
  <thead>
    <tr>
      <th scope="col">Username</th>
      <th scope="col">Email</th>
    </tr>
  </thead>
  <tbody>
    <?php while($row = mysqli_fetch_assoc($user)): ?>
      <tr>
        <td align = "center">
           <?php echo $row["username"]; ?>
        </td>
        <td align = "center">
           <?php echo $row["email"]; ?>
        </td>
      </tr>
    <?php endwhile; ?>
  </tbody>
</table>

Unless you need to put all users in a single <td>

answered May 15, 2018 at 22:06

Felippe Duarte

15.2k2 gold badges27 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

cannot reset query row after executing while loop

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related