All pastes #915735 Raw Edit

Someone

public text v1 · immutable
#915735 ·published 2008-02-24 00:25 UTC
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>';