My while loop won't work
<p>In this script, I basically want to echo out data from a mysql table when the certain row record matches the name in browser address bar. But for some reason, no data is echoed. Any reason my while loop doesn't work?</p>

<pre><code> $users = $_GET['username'];



$other_friend_query = mysql_query("SELECT * FROM friend WHERE RelatingUser='$users'");
$other_friend_assoc = mysql_fetch_assoc($other_friend_query);


while ($other_friend_assoc = mysql_fetch_assoc($other_friend_query)) {
    $friend_related = $other_friend_assoc['RelatedUser'];
      echo $friend_related;




  }
</code></pre>
