populate array with sql row values using php

[detox]

I can't get

'$cred1;' => '$cred2',

 

to populate with row1 and row2 values why?

how can i do this

Thank you

 

$RunThisQuery = "SELECT row1, row2 FROM frm_auth WHERE userid=".$_REQUEST['id'];
$results = $connector->query($RunThisQuery);
while ($row = $connector->fetchArray($results)){
$cred1=$row['row1'];
$cred2=$row['row2'];

$LOGIN_INFORMATION = array(
'$cred1;' => '$cred2',
'neverguess' => 'neverguess2'
);
}

[emehrkay]

single quotes are evaluated as what is in them, not as the variable's value.

 

so

$var = 'hey';

 

'$var' is actually '$var';

 

where as

 

"$var" is 'hey'

 

Try double quotes

[detox]

thanks that helped a bit, the problem now is: i have 5 entries in my sql row and only the last one is being recognized.

[detox]

i thing the cause of the problem is that when the rows are being looped no space is being put between them. Any ideas? Thanks

[detox]

ok after some review that may not be it either

[detox]

for some reason only the last loop pass is sticking

it doesnt print seperate array values like this

 

array( example1 => example1a, example2 => example2a

 

it just creates the last one:

array (example2 => example2a

[emehrkay]

I assume that the problem is that you are rewriting the same key so only the last one is staying. You could make it a multidimensional array

 

$LOGIN_INFORMATION = array();

while(){

$LOGIN_INFORMATION[] = array(

'key' => 'val'

);

}