[SOLVED] Populating an array with MySQL

[The Midnighter]

Hi there

 

I've read over about 10 examples of people populating arrays with mysql, however not one seemed to have helped me.

I am trying to simply populate a array.

 

$query = "SELECT * FROM `users`;";
$result = mysql_query($query);
$userDB = array();

while ($row = mysql_fetch_row($result))
{
             $user = $row['Username'];
             $pass = $row['Password'];
             $userDB[] = ($user => $pass);
}

 

Does not work, I've tried variations but I don't see a need to post that here.

Let me know if I can provide any more details,

thank you.

[.josh]

is that your entire code?

[iceblox]

I was looking for help on the same thing the other day!

 

Not sure it it will work but give this a try;

 

$query = "SELECT * FROM users";
$result = mysql_query($query);
if (mysql_num_rows($result) > 0) {
     while($row = mysql_fetch_array($result)) $arr[$row['Username']] = $row['Password'];
} else {
   echo 'No rows found!';
}

 

Phil

[The Midnighter]

Hi Phil,

 

I understand your code until you throw in $arr, where did you get that value from?

[iceblox]

Oops sorry missed a line!!

 

$arr = array();
$query = "SELECT * FROM users";
$result = mysql_query($query);
if (mysql_num_rows($result) > 0) {
     while($row = mysql_fetch_array($result)) $arr[$row['Username']] = $row['Password'];
} else {
   echo 'No rows found!';
}

 

Phil

[The Midnighter]

Hi again Phil.

 

Thanks for the repost, that's what I thought you meant.

 

So my code now looks like:

 

$query = "SELECT * FROM `users`;";
$result = mysql_query($query);
$userDB = array();

while ($row = mysql_fetch_row($result))
{
	$userDB[$row['Username']] = $row['Password'];
}

 

It's still failing however... There is only one user in my Database, it looks like this:

ID  Username  Password

1    blah          password

[iceblox]

Hmm,

 

Try and changing this line;

 

	while ($row = mysql_fetch_row($result))

 

to

 

	while ($row = mysql_fetch_array($result))

 

Did the code I sent you not work?

 

Phil

[The Midnighter]

Ah!

Changing it to mysql_fetch_array solved the problem, and I understand how this works, beautifuly.

 

Thank you Phil, I'd add to your reputation if I could figure out how =)

[iceblox]

No worries, glad I could help!

 

Don't forget to change the post to solved 

 

Phil