DB to Array with for

[megafu]

hi everyone ... :) having a little problem with this:

i have in my DB somethink like:  userID1 userID2 userID3 .. etc

and i would like to make a something that puts all thos values in a array so i can use it.

[code]
for ($id = 0; $id <= $allIDS; $id++)
{
$realID = $id+1:
$userID = "user".$realID ;
$myarray[$id] = $row ['$userID'];
}
[/code]

i tried to use whats above. but it did not work .:S dont really understand why, or can find any solution.

Reaaallyy need help. thanks .  8)

[BillyBoB]

try 
[code]
$results = mysql_query("SELET * FROM table");
$array = mysql_fetch_array($results);
[/code]