echo $user only echos out 1 user

[runnerjp]

<?php $result = mysql_query("SELECT * FROM useronline WHERE(file='http://www.runningprofiles.com/members/index.php?page=forum&forum=$forum')");
while($row = mysql_fetch_array( $result )) {

$last_active = time() - $row['timestamp'];
$onlineuser = $row['user'];
}

if($last_active < 300) {
echo $onlineuser;
}
?>

 

how comes this code only echo 1 user :S

[kenrbnsn]

Are there more that one user in your database that match the "where" condition?

 

Ken

[runnerjp]

yes there are... the where cluse is an address of the page they are on when on my website

[kenrbnsn]

You don't have the echo contained in the "while" loop.

 

Try:

<?php
$result = mysql_query("SELECT * FROM useronline WHERE(file='http://www.runningprofiles.com/members/index.php?page=forum&forum=$forum')");
while($row = mysql_fetch_array( $result )) {
    $last_active = time() - $row['timestamp'];
    $onlineuser = $row['user'];
    if($last_active < 300) {
         echo $onlineuser;
    }
}
?>

 

This is why indented code is very helpful.

 

Ken