Stuff

	<span id="mainrubrik">		<img src="grafik/ikoner/arrow.gif" title="Arrow" alt="Arrow" /> Media: Intervju	</span>	<br /><br />		<span id="preslinks">Sida: <a href="?location=media">Media</a> -> <a href="?location=intervju">Intervjuer</a></span>	<?PHP			if($_GET['location'] == "intervju" && isset($_GET['sub']) && sub == "makenew") {			echo"create";			} elseif($_GET['location'] == "intervju" && isset($_GET['read'])) {								$q=mysql_query("SELECT * FROM q_intervju WHERE id = '".$_GET['read']."'") or print(mysql_error());					if(mysql_affected_rows() == "0") 			{			echo"<hr />Det finns ingen intervju med detta ID-nummer!";			} 			else 			{ 			while($r=mysql_fetch_array($q)) 			{				$id=$r['id'];				$idskapare=$r['creater'];				$pubdate=$r['pubdate'];				$rubrik=$r['rubrik'];				$string=$r['string'];			} } // end while				$userquery=mysql_query("SELECT * FROM q_client WHERE id = '".$idskapare."'");			$rad=mysql_fetch_array($userquery) or exit ( mysql_error());			$skapare=$rad['username'];			$sid=$rad['id'];    			echo"<hr />";						echo"<span id=\"mainrubrik\">$rubrik</span><br />";			echo"$string";			echo"<hr />&bull; Publicerad av <span id=\"authorlink\"><a href=\"?location=profile&id=$sid\">$skapare</a></span> $pubdate";								} else {													$limit 		= 9; // rows to return    			$numresults = mysql_query("SELECT id FROM q_intervju ORDER BY id ");    			$numrows 	= mysql_num_rows($numresults);    	    			if(empty($_GET['offset']))     			{    			$offset=0;    			}    			else    			{    			$offset = addslashes($_GET['offset']);    			}						$q=mysql_query("SELECT * FROM q_intervju ORDER by id DESC LIMIT $offset, $limit ")or print(mysql_error());					if(mysql_affected_rows() == "0") 			{			echo"<hr />Det finns ingen intervju i databasen!";			} 			else 			{ 			while($r=mysql_fetch_array($q)) 			{				$id=$r['id'];				$idskapare=$r['creater'];				$pubdate=$r['pubdate'];				$rubrik=$r['rubrik'];				$string=$r['string'];				$userquery=mysql_query("SELECT * FROM q_client WHERE id = '".$idskapare."'");			$rad=mysql_fetch_array($userquery) or exit ( mysql_error());			$skapare=$rad['username'];			$sid=$rad['id'];    			echo"<hr />";						echo"<img src=\"grafik/ikoner/icon_intervju_rubrik.gif\" alt=\"\" /> <span id=\"mainrubrik\">$rubrik</span><br />";			echo"Publicerad av <span id=\"authorlink\"><a href=\"?location=profile&id=$sid\">$skapare</a></span> $pubdate";			echo"<br /><br />&bull; <span id=\"readmore\"><a href=\"?location=intervju&read=$id\">Läs denna intervju!</a></span>";						} } // end while								echo"<hr /><br />Fler sidor: ";					/*	if ($offset >= $limit)         	{         						$prevoffset=$offset-$limit;        						print "<a href=\"?location=imagemedia&amp;offset=$prevoffset\">Föregående sida</a> &nbsp; \n";        	}*/        	$pages=intval($numrows/$limit);        	        	if ($numrows%$limit)         	{        						$pages++;        	}        	        	for ($i=1;$i<=$pages;$i++)         	{ // loop thru        						$newoffset=$limit*($i-1);        						print "<span id=\"preslinks\"><a href=\"?location=intervju&amp;offset=$newoffset\">$i</a></span> \n";        	}        	        	/*if (!($offset/$limit) == $pages)         	{        						$newoffset=$offset+$limit;        						print "<a href=\"".$_SERVER['PHP_SELF']."?location=members&amp;offset=$newoffset\">Visa nästa $limit</a>\n";        	}*/												if(isset($_SESSION['clientsess'])) 			{			$query=mysql_query("SELECT * FROM q_client WHERE username = '".$_SESSION['clientsess']."'");			$row=mysql_fetch_array($query) or exit ( mysql_error());			$rank=$row['rank'];							if($rank == "2" || $rank == "3") 			{			echo"<p>[ <span id='preslinks'><a href='?location=intervju&sub=makenew'>Klicka här för att lägga till intervju</a></span> ]</p><br /><br />";						}		}							}	?>