INNER JOIN empty tom ingen ting
Hvorfor viser den ..... ingenting men den mælder ingen felt siden er bare blank.<?
$SQL = "
SELECT
host_lan.info as info,
host_lan.location as location,
host_lan.pn as pn,
host_users.user_name as user_name
FROM
host_users
INNER JOIN host_lan ON host_users.id = host_lan.id
WHERE
user_name='". $_SESSION['logged_name'] ."'
LIMIT 1";
$loadin = mysql_query($SQL) or die(mysql_error() ."<br>".nl2br($sql));
while ($Get = mysql_fetch_object($loadin)){
?>
<tr align="center" bgcolor="#999999">
<td bgcolor="D6D6D6" width="100%" style="border: 1px black solid;" colspan="2">
Join Lans
</td>
</tr>
<form action="insert.php" method="post">
<input type="hidden" value="insert host_join" name="do">
<tr>
<td bgcolor="D6D6D6" width="60%"><?=$Get->name?></td>
<td bgcolor="D6D6D6" width="40%"><input name="name" type="text" style="font-size:9px; height:20px; width:200px; background-color: D6D6D6;" readonly="" value="<?=$Get->pn?>" maxlength="20"></td>
</tr>
<tr>
<td colspan="2" bgcolor="EAEAEA"><strong>Lan Info:</strong><br><?=$Get->info?></td>
</tr>
<tr>
<td colspan="2" bgcolor="EAEAEA"><strong>Location:</strong> <?=$Get->location?></td>
</tr>
<tr>
<td width="60%" bgcolor="D6D6D6">
Start Date: <?=$Get->start_date?> (M-D-Y)
</td>
<td width="40%" bgcolor="D6D6D6">
<?=$Get->gmt?>
</td>
</tr>
<tr>
<td bgcolor="EAEAEA" colspan="2" align="center"><input type="submit" style="font-size:9px; height:20px;" value="Join lan <?=$Get->user_name?>"></td>
</tr>
<td>
</td>
</tr>
<input type="hidden" value="<?=$_SESSION['yes']?>">
<? $_SESSION['secret'] = "wtf/!"?>
</form>
<?
}
Db::Conn(close);
?>
