Assign Two tables into php array and display the array

Question

How to assign two tables into a single array and then display it with foreach loop:

TABLE: 1

pcode       rate
------------------------------
aaa         10
bbb          5
ccc          4

TABLE: 2

 pcode       sales
------------------------------
aaa         250
bbb         100
ccc          40

I have tried so far as:

$final=array();
foreach($table1 as $t1)
        $final [$t1->code][0] = $t1->rate;

    foreach($table2 as $t2)
        $final [$t2->code][1] = $t2->sales;




    foreach ($final as $c=>$v){
        echo "$c $v[0]  $v[1]" . "\n";   \\error
    }

Please suggest?

Answer 1

    $final=array();
    foreach($table1 as $t1)
            $final [$t1->code]['rate'] = $t1->rate;

        foreach($table2 as $t2)
            $final [$t2->code]['sale'] = $t2->sales;
$table='<table><tr>
<td>name</td>
<td>Sale</td>
<td>Purcahse</td>
</tr>';


    foreach ($final as $c=>$v){
$table.='<tr>
<td>'.$c.'</td>
<td>'.((isset($v['rate']))?$v['rate']:'').'</td>
<td>'.((isset($v['sale']))?$v['sale']:'').'</td>
</tr>';

    }
$table.='</table>';