gegevens uit 2 tabellen combineren

<?php
$table2="toestellen";


$result=mysql_query("select * from $table2");

$out = ''; 

$fields = mysql_list_fields(gerits_r_be,$table2);

$columns = mysql_num_fields($fields);

while ($l = mysql_fetch_array($result)) {
	for ($i = 0; $i < $columns; $i++) {
			$out .=$l["$i"].';';
	}
}

$f = fopen ('toestellen.txt','w');

fputs($f, $out);
fclose($f);
?>

<?php
$table2="toestellen";
 
 
$result=mysql_query("select * from $table2");
 
$out = ''; 
 
$fields = mysql_list_fields(gerits_r_be,$table2);
 
$columns = mysql_num_fields($fields);
 
while ($l = mysql_fetch_array($result)) {
	for ($i = 0; $i < $columns; $i++) {
			$out .=$l["$i"].';';
	}
}
 
$f = fopen ('toestellen.txt','w');
 
fputs($f, $out);
fclose($f);
?>

$result=mysql_query("select * from " . $table2);
...
$out .=$l[$i].';';

$result=mysql_query("select * from " . $table2);
...
$out .=$l[$i].';';

SELECT * FROM klanten INNER JOIN producten ON (klanten.id = producnten.klantID)

SELECT * FROM klanten INNER JOIN producten ON (klanten.id = producnten.klantID)