Hi,

I would like to build the following array dynamically, getting both the key and value from the database.

PHP Code:

array('http://www.google.com/' => 'Google','http://live.com/' => 'Microsoft Live'); 


Right now i have this:

PHP Code:

$linkstring = array();
while ($qry = mysql_fetch_array($sql)) {
     $linkstring[] = array('siteaddress' => 'sitename');
} 


Note that siteaddress and sitename should become a variable, but i have made them static just for testing.

The output of the values of the above is however a list of the word 'Array', instead of a list of the word 'sitename'. What am i doing wrong?

thanks!

Matt

The output of that should be an array of 'siteaddress'=>'sitename' key/value pairs of however many rows teh query returns.

That should work however. If you populate the variables to put in the array something like...

PHP Code:

$siteAddress = $qry['siteaddress'];
$siteName = $qry['siteName']; 


Oh wait, you are created a 2 dimenional array when you only want a key/value paired array.

try...

PHP Code:

$linkString[$siteAddress] = $siteName; 


Incidentally, are you sure you dont want the keys/values the other way around so you can access the address from the site name?

Hope this helps....

Wonderfull, thanks, that works fine!