Menu
Community /Pin to ProfileBookmark
@NogDogDec 22.2005 — #
element of a multi_D array
Hey,
I have a database that I call some data from and store it in a 2 column array….[id, name]
I have another call to a different database that stores its data…[date, to, duration, rate]
now the ‘to’ column is an id number that relates to the id column of the 1st array.
I need to populate a table, but want the name from array1 to show up.
What is the best method for retreiving this?
I’m sure there is a common method, but as both these are written to a table that needs to appear almost instantaneously, what is the cleanest method?
Thx for your help.
Sign in
to post a comment8 Comments(s) ↴
0
@NogDogDec 22.2005 — #[code=php]
<?php
# test data:
$array1 = array(array('id' => 1, 'name' => 'Manny'),
array('id' => 2, 'name' => 'Moe'),
array('id' => 3, 'name' => 'Jack'));
$array2 = array(array('date' => '2005/12/21',
'to' => 1,
'duration' => 11,
'rate' => 111),
array('date' => '2005/12/22',
'to' => 2,
'duration' => 12,
'rate' => 112),
array('date' => '2005/12/23',
'to' => 3,
'duration' => 33,
'rate' => 333));
# merge the two arrays on the id/to columns:
foreach($array1 as $data)
{
$merged[$data['id']]['name'] = $data['name'];
}
foreach($array2 as $data)
{
foreach(array('date', 'duration', 'rate') as $name)
{
$merged[$data['to']][$name] = $data[$name];
}
}
# test result:
echo "<pre>";print_r($merged);echo "</pre>n";
?>
[/code]