循环运行9次并逐渐获得信息

Question

I'm trying to pull in some data from my database, and the loop is behaving strangely. this is

my code:

<code>
  $query = "SELECT DISTINCT * FROM users WHERE username LIKE '%$search%'";

  $resultpage = "";

  $result = mysqli_query($con,$query);

  $rows = array();

  $resultpage = "<table class='table table-striped table-hover><tbody><tr><td>Search Results</td></tr>";

  while($row = mysqli_fetch_assoc($result)) {
    $rows[] = $row;

    foreach($rows as $row) {
      foreach($rows as $field => $value) {          
        array_unique($rows);
        $resultpage .= "<tr><td><a href='user?id=".$value["id"]."'>".$value["username"]."</a></tr></td>";
      }
    }      
  }
</code>

You can see what is output here.

Basically, there are patterns of duplicate entries, and some of the entries don't even appear until you get farther down the list.

Thanks for any help

Answer 1

I am chancing a bit now:

<code>
  $query = "SELECT DISTINCT * FROM users WHERE username LIKE '%$search%'";

  $rs = mysqli_query($con,$query);

  echo "<table class='table table-striped table-hover'><tbody><tr><td>Search Results</td></tr>";

  while($row = mysqli_fetch_assoc($rs)) {    
    $id = $row["id"];
    $username = html_encode($row["username"]);
    echo "<tr><td><a href='user.php?id=$id'>$username</a></td></tr>";
  }

  echo "</table>";
</code>