how to merge these 2 arrays (php+sql)

I have 2 arrays, both from a SQL query, each from a different database. Since it's not possible to merge these 2 SQL queries into 1 query to get 1 array (due to some restrictions), I am forced to combine the 2 arrays. Problem is, I can't seem to get this working.

This is array 1:

echo '<ul id="friends">';
    foreach($result as $friend => $value)
        {
            echo '<li><img src="'.$value['pic_square'].'" alt="" />'.$value['uid'].' ' . $value['name'] . '</li>';
        }
    echo '</ul>';

And wi开发者_C百科ll output:

• picture 12345 Dave
• picture 67890 Mike
• Etc

This is array 2:

echo '<ul id="friends">';
    while($value = mysql_fetch_array($query))
        {
        echo '<li> '.$value['fbid'] .' '. $value['userphone'] .'</li>';

        }
    echo '</ul>';

And will output:

• 12345 020-12345
• 67890 020-56789
• Etc

What do I need? I want to merge these 2 arrays so that the phonenr from array 2 will be added behind the username from array 1.

Example what the output should look like:

• picture Dave 020-12345
• picture Mike 020-56789
• Etc

fbid and uid are the id's to link each other, but are not shown in the combined array.

Hope someone knows how to do this!

Kind regards,

Maurice

This is the simplest and most efficient way I could think of doing it. The foreach loop iterates through your first array and basically add new key/value pairs using the "uid" as the key. This will enable you to easily find them when you loop through the second query's results.

<?php

// First query.
foreach ( $result as $key => $value )
{
  // Add a new key/value pair in the array using the "uid" as the key and $value as the value.
  $result[$value['uid']] = $value;

  // Remove the previous key/value pair value.
  unset($result[$key]);
}

// Second query.
while ( $value = mysql_fetch_array($query) )
  echo sprintf('<li>%s %s %s</li>', $result[$value['fbid']]['pic_square'], $result[$value['fbid']]['name'], $value['userphone']);

As the array collection names are different (different column name) I am not sure direct merging will work.

$result = array_merge($result, $query);
print_r($result);

But you can work around like below.

Give loops and store in a third array from both the arrays and do necessary actions on third array.