Min SQL setning henter ikke opplysninger fra DBen hvorfor
Hej jeg har problemer med at få men SQL setning til at virke...Kan i ikke hjælpe mig med mit problem...
Her er min kode.
<?
Db::Conn("open");
$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(Java::Alert("Mysql Error.: ".mysql_error()));
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>
<tr>
<td>
</td>
</tr>
<input type="hidden" value="<?=$_SESSION['yes']?>">
<? $_SESSION['secret'] = "wtf/!"?>
</form>
<?
}
Db::Conn(close);
?>
