1: 
2: 
3: 
4: 
5: 
6: 
7: 
8: 
9: 
10: 
11: 
12: 
13: 
14: 
15: 
16: 
17: 
18: 
19: 
20: 
21: 
22: 
23: 
24: 
25: 
26: 
27: 
28: 
29: 
30: 
31: 
32: 
33: 
34: 
35: 
36: 
37: 
38: 
39: 
40: 
41: 
42: 
43: 
44: 
45: 
46: 
47: 
48: 
49:

echo '
	<table border="1">
		<tr>
			<td>Planet / Gebäude</td>
		
	';

$gebaeude_id			= 	array();
$plani_gebaeude_id		=	array();
$arbeiter 				= 	array();
$energie 				= 	array();
$rohstoffe 				= 	array();
$forschung 				=	array();
$plani_gebaeude_anzahl	=	array();

while($building_info = mysql_fetch_array($glob_buildings))
	{
	 	$gebaeude_id[] = $building_info['gebaeude_id'];
	 	$plani_gebaeude_id[] = "gebaeude_id_".$building_info['gebaeude_id'];
	 	$arbeiter[] = $building_info['arbeiter'];
	 	$energie[] = $building_info['energie'];
	 	$rohstoffe[] = $building_info['rohstoffe'];
	 	$forschung[] = $building_info['forschung'];
		echo '<td><img src="../graphics/trans250x1.gif"><br>'.$building_info['gebaeude_name'].' ('.$building_info['gebaeude_id'].')</td>';
	}

$anzahl = count($gebaeude_id);

while($plani_info = mysql_fetch_array($glob_planis))
	{
	 	echo '<tr height="500"><td>'.$plani_info['id'].'</td>';
				
				for($i=0;$i<$anzahl;$i++){
					$plani_gebaeude_anzahl[] = $plani_info[$plani_gebaeude_id[$i]];
				}
				
				for($i=0;$i<$anzahl;$i++){
			echo '
				<td>'.$plani_gebaeude_anzahl[$i].'<br>
				x A '.$arbeiter[$i].' = '.$plani_gebaeude_anzahl[$i]*$arbeiter[$i].'<br>
				x E '.$energie[$i].' = '.$plani_gebaeude_anzahl[$i]*$energie[$i].'<br>
				x R '.$rohstoffe[$i].' = '.$plani_gebaeude_anzahl[$i]*$rohstoffe[$i].'<br>
				x F '.$forschung[$i].' = '.$plani_gebaeude_anzahl[$i]*$forschung[$i].'</td>';
		}
		unset($plani_gebaeude_anzahl);
		echo '</tr>';
	}
echo '
	</table>';

1: 
2: 
3: 
4: 
5: 
6: 
7: 
8: 
9: 
10: 
11: 
12: 
13: 
14: 
15: 
16: 
17: 
18: 
19: 
20: 
21: 
22: 
23: 
24: 
25: 
26: 
27: 
28: 
29:

$glob_buildings = db_query("SELECT * FROM ".$db_prefix."_gebaeude");
$glob_planis = db_query("SELECT * FROM ".$db_prefix."_universe WHERE owner_id != 0");
echo '
	<table border="1">
		<tr>
			<td>Planet / Gebäude</td>
		
	';
while($building_info = mysql_fetch_array($glob_buildings))
	{
		echo '<td>'.$building_info['gebaeude_name'].' ('.$building_info['gebaeude_id'].')</td>';
	}

while($plani_info = mysql_fetch_array($glob_planis))
	{
	 
		echo '<tr><td>'.$plani_info['id'].'</td>';

			while($building_info_2 = mysql_fetch_array($glob_buildings))
				{
				 	$building_info_2_id = $building_info_2['gebaeude_id'];
					echo '<td>'.$plani_info['gebaeude_id_'.$building_info_2_id].'</td>';
				}
				echo '</tr>';
	}
echo '
	</table>';

1:

$glob_buildings_2 = db_query("SELECT * FROM ".$db_prefix."_gebaeude");

1:

while($building_info_2 = mysql_fetch_array($glob_buildings_2))