rendered paste body$query1 = mysql_query("SELECT * FROM posts WHERE id = '".$_GET['TradSpilid']."'");
while($line1 = mysql_fetch_array($query1))
{
$racen = $line1['race'];
if($racen == "Vampyrer")
{
$query2 = mysql_query("SELECT * FROM Vampyrer, posts
WHERE posts.fk_traade = '".$_GET['TradSpilid']."'
AND posts.fk_karakter = Vampyrer.id");
}
elseif($racen == "Lycans")
{
$query2 = mysql_query("SELECT * FROM Lycans, posts
WHERE posts.fk_traade = '".$_GET['TradSpilid']."'
AND posts.fk_karakter = Lycans.id");
}
elseif($racen == "mennesker")
{
$query2 = mysql_query("SELECT * FROM posts, mennesker
WHERE posts.fk_traade = '".$_GET['TradSpilid']."'
AND posts.fk_karakter = mennesker.id");
}
if(mysql_num_rows($query2) == 0)
{
echo 'Der er ingen svar!';
}
else
{
echo '<table width="470" border="0" cellspacing="0" cellpadding="0">
<tr style="background-image:url(pics/top.gif);">
<td width="120" align="top" scope="col"><b>Information:</b></td>
<td width="350" align="top" scope="col"><b>Post:</b></td>
</tr>';
while($line2 = mysql_fetch_array($query2))
{
echo '<tr>';
echo '<td class="postinfo"> <b>Karakter:</b> <br />
'.$line2['fornavn'].' '.$line2['efternavn'].'<br /></td>';
echo '<td class="postmain">'.$line2['post'].'</td>';
echo '</tr>';
}
}
} echo '</table>';