Udskriver mysql udtræk to gange?
Den udskriver mine bannere 2 gange, medmindre jeg kun har et oprettet banner?<?
$sqlkate_n = mysql_query("select * from banner_kategori where id = '$_GET[id]'");
$kate_navn = mysql_fetch_array($sqlkate_n);
?>
<?
$res = mysql_query("select * from banner where kategori = '$_GET[id]'");
if(mysql_num_rows($res) == 0){
echo "<CENTER>Ingen annoncører i denne kategori</CENTER>";
}else{
while ($row = mysql_fetch_assoc($res)) {
?>
<?
$resbanner = mysql_query("select * from banner where kategori = '$_GET[id]'");
if(mysql_num_rows($resbanner) == 0){
?>
<?
}else{
while ($row = mysql_fetch_array($resbanner)) {
if($row[bannerkode] == ""){
?>
<table width="519" height="100">
<tr><td bgcolor="#EEE3CD" style="padding-left:8px;" style="padding-top:8px;" valign="top">
<a target="popup" href="http://<?=$row[link]?>"><img style="boder:1px solid #000000;" border="0" src="getimg.php?id=<?=$row[id]?>" width="468" height="60"></a><br>
<?=$row[beskrivelse]?><br>
</td>
</tr>
</table>
<? }else{ ?>
<table width="519" height="100">
<tr><td bgcolor="#EEE3CD" style="padding-left:8px;" style="padding-top:8px;" valign="top">
<?=$row[bannerkode]?><br>
<?=$row[beskrivelse]?><br>
</td>
</tr>
</table>
<?} } } }}?>
