Display multiple entries

[adamFTW]

<?php
include ("includes/global.php");

$n = mysql_query("SELECT uid FROM updates WHERE uid = '$oid'");
$number = mysql_num_rows($n);

$u = mysql_query("SELECT * FROM updates WHERE uid = '$oid'");
$update = mysql_fetch_array($u);

$user = mysql_query("SELECT * FROM users WHERE id = '$oid'");
$username = mysql_fetch_array($user);

if($number == "0"){
    echo "You have no status updates.";
} else {
    echo "{$username['username']} is {$update['message']}";
}

?>

right now it only displays the most recent update, how do I make it display all the entries by that user? thx

Edit by Robbie! (Forum Moderator) - Moved to Coding Help, please post in the correct section next time, thanks.

[Joe!]

I think this would work.

<?php
include ("includes/global.php");

$n = mysql_query("SELECT uid FROM updates WHERE uid = '$oid'");
$number = mysql_num_rows($n);

$u = mysql_query("SELECT * FROM updates WHERE uid = '$oid'");

$user = mysql_query("SELECT * FROM users WHERE id = '$oid'");
$username = mysql_fetch_array($user);

if ($number == "0")
{
    echo "You have no status updates.";
}
else
{
    while ($update = mysql_fetch_array($u))
    {
        echo "{$username['username']} is {$update['message']}";
    }
}

?>