2 result sets into one array

[stefke]

I have two tables
and I want to query both tables on a search string (one form for our customers)

both have a separate structure
but the fields id, titel and searchwords are common in both tables

so that should be possible

unfortunately union is not supported on our webhosts version of mysql

$result=mysql_query("SELECT * FROM lang0506 WHERE trefwoorden LIKE '%$trefwoorden%' ORDER by titel limit $offset,$limit");

while ($row = mysql_fetch_array($result)) {

so the question is, if I add a $result2 querying the table kortnj05 with the same query

how do i get that in $row? what's the correct syntax for that?

tnx very much in advance for any help

[devinemke]

function do_query($table) 
{ 
    global $trefwoorden, $offset, $limit; 

$result = mysql_query("SELECT * FROM $table WHERE trefwoorden LIKE '%$trefwoorden%' ORDER by titel LIMIT $offset, $limit;") or exit(mysql_error()); 
while ($row = mysql_fetch_assoc($result)) {$array[] = $row;} 

return $array; 
} 

$array1 = do_query('lang0506'); 
$array2 = do_query('kortnj05'); 

foreach ($array2 as $value)
{
	$array1[] = $value;
}

print_r($array1);