array from query then random gen. of array

[sk121506]

I'm trying to make an array from a query and then randomly select 10 values from the array, but the error i keep getting is that it's not reading as an array. Thanks in advance for anyone who can help.

$query = "SELECT Id FROM January WHERE Username='0' AND Day='1'";
$result = mysql_query($query);

while($row=mysql_fetch_assoc($result)) 
{ 
echo $row['Id'];
echo "<br>";
}

for($i=1; $i<=10; $i++){
$random = array_rand($row);
echo $random;
}
?>

 

MOD EDIT: code tags added so the code makes a little more sense

[sk121506]

bump. anyone!?

[Barand]

try

<?php
$query = "SELECT Id FROM January WHERE Username='0' AND Day='1'";
$result = mysql_query($query);

$data = array();
while($row=mysql_fetch_assoc($result)) 
{ 
    $data[] = $row['Id']; // store in array
}

$random = array_rand($data, 10);    // get 10 random keys

foreach ($random as $key)
{
    echo $data[$key] ;
}
?>

[sk121506]

that is BEAUTIFUL! THANK YOU SO MUCH!