[RESOLVED] Only gives one array result?

[homchz]

function match_username() 
		{
			$connection = new db_connect;
			$connection->connect();
			$this->table  = "bs_user_member";
		 	$this->query  = mysql_query("SELECT username FROM $this->table");
				while ($this->result = mysql_fetch_object($this->query))
				{
					global $uname;

				$uname = array($this->result -> username);
			}

	}

Should show all right?

[Rodney_H_]

I think it might be this:

$uname = array($this->result -> username);
 

Maybe change it to:

$uname[] = $this->result -> username;

[thorpe]

what?

[homchz]

whom ever replied with

$uname[] = $this->result -> username;

earlier. That fixed it.

Thanks, not sure where the post went though.

[Rodney_H_]

Sorry, that was me.

My point was that if you used the line: $uname = array($this->result -> username);

Each time your while loop iterates, it updates the array value with the latest value from the db.

However if you use: $uname[] = $this->result -> username; the first array key begins with an index of zero and each new value from the db gets added to the array with a new index incremented by 1.

[homchz]

Thanks for the explination too.
I was wondering what I did wrong

Funnty though the first way worked with some code modifications outside of the funtion, just not it.