1. query:
$result=$db->query("SELECT * FROM gegnerplan".$oby);

2. query:
$result2=$db->query("SELECT g.*,u.*,a.* FROM gegner AS g, users AS u, allianzen AS a WHERE g.gegnerid='".$row['gegnerid']."' AND a.allianzid=g.allianzid AND u.userid=".$row['scanfrom']."".$oby2);

FROM gegnerplan".$oby

<?PHP
session_name("cxid");
session_start();
$sid=session_id();

if (!isset($_SESSION['userid']))
{
	header("LOCATION: index.htm");
	exit();
}

if(isset($_REQUEST['action']))
{ $action=$_REQUEST['action'];
}else{ $action="main";}

if(isset($_REQUEST['sort']))
{
	if ($_REQUEST['sort']=="gegnername")
	{
		$oby2=" ORDER BY g.gegnername ASC"; //DET FUNTZT NEDDE *grml*
	}else{
		$oby=" ORDER BY ".$_REQUEST['sort']." ASC";
	}
}

require ("./lib/db_conn.php");

if ($action==main)
{
$result=$db->query("SELECT * FROM gegnerplan".$oby);
}

...
...
hier sind noch weitere if ($action==)
...
while ($row=$db->fetch_array($result))
{
	if ($t2 != 1)
	{
	$result2=$db->query("SELECT g.*,u.*,a.* FROM gegner AS g, users AS u, allianzen AS a WHERE g.gegnerid='".$row['gegnerid']."' AND a.allianzid=g.allianzid AND u.userid=".$row['scanfrom']."".$oby2);
	$gegner=$db->fetch_array($result2);
	}else{
	$result2=$db->query("SELECT * from allianzen where allianzid=".$_REQUEST['allianzid']);
	$gegner=$db->fetch_array($result2);
	$gegner['gegnername']=$row['gegnername'];
	}

	$lastscan= date("H:i:m d.m.Y",$row['lastscan']);

	$tooltip= "\"Hyperraumantrieb: ".$gegner['hyperraum']."|Impulstriebwerk: ".$gegner['impuls']."|Triebwerktechnik: ".$gegner['triebwerk']."\"";
	$planeten .= "<tr>
					<td width=\"10%\" title= $tooltip>".$gegner['gegnername']."</td>
					<td width=\"8%\">".$row['planname']."</td>
					<td width=\"8%\">".$gegner['allianzname']."</td>
					<td width=\"12%\">".$row['x'].":".$row['y'].":".$row['z']."</td>
					<td width=\"10%\">".$lastscan."</td>
					<td width=\"10%\">".$gegner['username']."</td>
					<td width=\"8%\"><a href=\"enterup.php?action=editgegner&id=".$row['id']."\">[edit]</a></td><td width=\"10%\"><a href=\"enterup.php?action=delgegnerplan&id=".$row['id']."\">[del]</a></td>
				</tr>";
}


?>

im HTML:

...
...
...
<tr>
      <td width="20%" rowspan=2>Name</td>
      <td width="8%" rowspan=2>Planet</td>
      <td width="8%"rowspan=2>Allianz</td>
      <td width="12%"rowspan=2>Koordinaten</td>
      <td width="8%" align="center" colspan="2">eingetragen </td>
      <td width="8%" rowspan=2></td>
      <tr>
      <td width="4%" align="center">am</td>
      <td width="4%" align="center">von</td>
    </tr>
    <?PHP
    echo $planeten;
    ?>

...
...