Problems with echoing array values

Question

I am having trouble echoing values from an array. I am using a mysql query to create an array, $online, containing the names of currently online users. Here is my code:

<?php
    $goodbye = time() - 300;
    $qry="SELECT UserName FROM Members WHERE Seen >=$goodbye";
    $result=mysql_query($qry);

    if($result) {
        $online = mysql_fetch_assoc($result);
        foreach($online as $u) {
            echo $u;
            echo "<br>";
        }
    } else {
        die("Query Failed");
    }
?>

When viewing this on my web page, only the first index of the array is shown (as in: if User1, User17, and User69 are all online, only User1 will appear on the list). I'm sure this is happening because I'm using echo incorrectly, but I haven't been able to figure it out yet. Any tips? Thanks.

mysql_query and its related family of functions are ancient and you should no longer be using them. They have been deprecated, and will shortly be removed from the language. Please find a tutorial on PHP Data Objects. — user229044
– user229044 ♦, Commented Oct 6, 2013 at 19:59
@meagar Yes, I am aware of that. That's not my problem here, though. — tboneblaze
– tboneblaze, Commented Oct 6, 2013 at 20:02

The Alpha · Accepted Answer · 2013-10-06 20:08:13Z

1

You should loop it like (mysql_fetch_assoc)

if($result) {
    while ($row = mysql_fetch_assoc($result)) {
        echo $row["UserName"];
    }
}

Also, notice the Warning.

edited Oct 6, 2013 at 20:08

answered Oct 6, 2013 at 20:02

The Alpha

147k30 gold badges294 silver badges313 bronze badges

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

1 Comment

tboneblaze Over a year ago

Also, I am aware of the warning. I'm currently working on going through my site and updating all of that.

Collectives™ on Stack Overflow

Problems with echoing array values

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related