What is wrong with this code?

[ERuiz]

I am trying a very simple plugin to display some results on a member's profile page. Look at the following code:

$pilotid = $userinfo['userid'];
$pilotid = "VAA".$pilotid;
$getlatestpireps = $db->query_read("SELECT * FROM pirep WHERE pilot_id = '$pilotid' ORDER BY date DESC LIMIT 10");
while ($row = $db->fetch_array($getlatestpireps)) {
$latest_pireps = $row['date'];
}

It will only display 1 result (the LAST result), instead of 10. What is wrong with it? Thanks for any help.

[Marco van Herwaarden]

Change:
$latest_pireps = $row['date'];
to:
$latest_pireps .= $row['date'];

[ERuiz]

Change:
$latest_pireps = $row['date'];
to:
$latest_pireps .= $row['date'];

Hello sir,

Thanks for your reply! :up: Ok, I did what you suggested and here is what happens now:

http://www.virtualaa.com/forums/member.php?u=1

Any idea? :)

[Marco van Herwaarden]

Your question was why only the last entry was shown, that was easy ;) as you would overwrite the previous entry each time you went thru the loop.

If the result is what you expect that is a totally different question, and as i don't know what you expect to happed, i can not answer it.

[ERuiz]

Your question was why only the last entry was shown, that was easy ;) as you would overwrite the previous entry each time you went thru the loop.

If the result is what you expect that is a totally different question, and as i don't know what you expect to happed, i can not answer it.

I fixed it. I had to change the hook to members_complete. It was set at members_customfields, so it was being called everytime a custom field was loaded.

THANKS because you did answer my question! lol