0) { print "\n"; print "Doomsday Space:\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { print "\t\n"; $sql = sprintf("SELECT nick from player WHERE id='%s'",$line["player_id"]); $player = mysql_query($sql,$db); $player = mysql_fetch_array($player); printf("\t\t\n",$player["nick"]); $sql = sprintf("SELECT name from unittype WHERE id='%s'",$line["unit_id"]); $unit = mysql_query($sql,$db); $unit = mysql_fetch_array($unit); $unit = $unit["name"]; print "\t\t\n"; if($line["target_id"]) { $sql = sprintf("SELECT player_id from space WHERE id='%s'",$line["target_id"]); $target = mysql_query($sql,$db); $target = mysql_fetch_array($target); $sql = sprintf("SELECT nick from player WHERE id='%s'",$target["player_id"]); $target = mysql_query($sql,$db); $target = mysql_fetch_array($target); printf("\t\t\n",$target["name"],$line["target_id"]); } else print "\t\t\n"; printf("\t\t\n",$line["distance"]); print "\t\n"; } print "

Player	Unit	Target	Distance
%s	$unit	%s's",$target["nick"]); $sql = sprintf("SELECT unit_id from space WHERE id='%s'",$line["target_id"]); $target = mysql_query($sql,$db); $target = mysql_fetch_array($target); $sql = sprintf("SELECT name from unittype WHERE id='%s'",$target["unit_id"]); $target = mysql_query($sql,$db); $target = mysql_fetch_array($target); printf("%s(%s)		%.2fAU

\n"; } mysql_close($db); ?>