Mysql Usernames in an array?

[whiteboikyle]

Well i was trying to put all the usernames i get from the mysql query into an array.. Here is what i got so far.. but it doesn't work.. Any suggestions?

$result = $config->query("SELECT * FROM members limit 20");
for ($i = 0; $i < mysql_num_rows($result); $i = $i + 1)
	{
	$name = mysql_result($result, $i, "username");
              $id = mysql_result($result, $i, "id");
	$username = array($name => $id);
	}
	echo $username['whitey'];

 

[mmarif4u]

Did you tried while loop.