inserting results from mySQL into array

[ucbones]

I have a login script running, worked great, with one username password combo

$user_passwords = array (
	"username1" => "password1", 
	);

However, I now want to add more users, the usernames and passwords are stored in a mySQL database table.

I tried doing this:

$linkjournal = mysql_connect("localhost", "mysqluser", "pass");
$selectjournal = mysql_select_db("mydb");
$result = mysql_query("SELECT user, pass FROM users");
 while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
  $user_passwords = array (
	$row[0] => $row[1],
	);

But it only retains the last row (and hence only one username password combination) in the array. I searched in the manual, but none of the examples helped. I'm sure this is really simple, but I'm stumped,

Many thanks,

ucbones

[bad76]

Hi,
try to look these other two thread:

"Dynamically create associative array" in "General help" forum
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10239451

"Creating array from sql query results??" in "Database" forum
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10239440

[ucbones]

Hi,

Thanks for digging that up for me,

$user_passwords = array();
$linkjournal = mysql_connect("localhost", "dbuser", "dbpass");
$selectjournal = mysql_select_db("db");
$result = mysql_query("SELECT user, pass FROM users");
 while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
 $username = $row['user'];
 $password= $row['pass'];
 $user_passwords[$username]=$password;
 }

Still doesn't work, only the last entry in the database returns a valid login. Any ideas?

ucbones

[ucbones]

Actually,

Worked perfectly, just my form fields were called username and password, so that mucked it up, all fixed now, many thanks for your help!

ucbones