Displaying custom code on Member List page

[ERuiz]

Hello everyone. I have created a very crude plugin (first ever attempt), which essentially displays a result for each member shown on the Member List.

Here is the custom plugin:

$pilotid = $userinfo['userid'];
$pilotid = "VAA".$pilotid;
$getlatestpirep = $db->query_read("SELECT * FROM pirep WHERE pilot_id = '$pilotid' ORDER BY date DESC LIMIT 1");
while ($row = $db->fetch_array($getlatestpirep)) {
$latest_pirep = "<a href=\"../livedispatch/pirep_details.php?pirep_id=".$row['pirep_id']."\">".$row['flight_number']."</a>";
}

The problem I am getting, is that once a member does not return a null value, it will display the result for all members after him having the same result.

If you go HERE, you will see that all members AFTER my name, have the same result for that field column.

In that case, since I am the ONLY member with a flight submitted, my name should be the only one displaying the latest flight.

Can someone see what I could be doing wrong?

Here is how the plugin is setup:

Hook Location: memberlist_bit

Thanks for any help...

UPDATE! Nevermind, I got it working.