Foutje in php van bannersysteem

 <?php


//get banner
$allbanner = safe_query("SELECT * FROM ".PREFIX."bannerrotation WHERE displayed='1'");
$total = mysql_num_rows($allbanner);
if($total) {
	$end = round(rand(1, $total));
	$banner = mysql_fetch_array(safe_query("SELECT * FROM ".PREFIX."bannerrotation WHERE displayed='1' LIMIT ".($end-1).",$end"));
	
if($file_ext==".gif" OR $file_ext==".jpg" OR $file_ext==".png")	echo '<a href="out.php?bannerID='.$banner['bannerID'].'" target="_blank"><img src="./images/bannerrotation/'.$banner['banner'].'" border="0" alt="'.$banner['bannername'].'"></a>';
else ($file_ext==".swf") echo '<OBJECT classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
 codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" 
 id="tryout" ALIGN="" WIDTH="468" HEIGHT="60">
 <PARAM NAME=movie 
 VALUE="../images/bannerrotation/'.$banner['bannerID'].'.swf"> <PARAM NAME=quality VALUE=high> <PARAM NAME=bgcolor VALUE=#FFFFFF> 
 <EMBED src=""../images/bannerrotation/'.$banner['bannerID'].'.swf" quality=high bgcolor=#FFFFFF  
 WIDTH="468" HEIGHT="60"  NAME="tryout" ALIGN=""
 TYPE="application/x-shockwave-flash" PLUGINSPAGE="http://www.macromedia.com/go/getflashplayer"></EMBED></OBJECT>';
} else echo 'no banners';
unset($banner);
?>

<?php
 
 
//get banner
$allbanner = safe_query("SELECT * FROM ".PREFIX."bannerrotation WHERE displayed='1'");
$total = mysql_num_rows($allbanner);
if($total) {
	$end = round(rand(1, $total));
	$banner = mysql_fetch_array(safe_query("SELECT * FROM ".PREFIX."bannerrotation WHERE displayed='1' LIMIT ".($end-1).",$end"));
 
if($file_ext==".gif" OR $file_ext==".jpg" OR $file_ext==".png")	echo '<a href="out.php?bannerID='.$banner['bannerID'].'" target="_blank"><img src="./images/bannerrotation/'.$banner['banner'].'" border="0" alt="'.$banner['bannername'].'"></a>';
else ($file_ext==".swf") echo '<OBJECT classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
 codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" 
 id="tryout" ALIGN="" WIDTH="468" HEIGHT="60">
 <PARAM NAME=movie 
 VALUE="../images/bannerrotation/'.$banner['bannerID'].'.swf"> <PARAM NAME=quality VALUE=high> <PARAM NAME=bgcolor VALUE=#FFFFFF> 
 <EMBED src=""../images/bannerrotation/'.$banner['bannerID'].'.swf" quality=high bgcolor=#FFFFFF  
 WIDTH="468" HEIGHT="60"  NAME="tryout" ALIGN=""
 TYPE="application/x-shockwave-flash" PLUGINSPAGE="http://www.macromedia.com/go/getflashplayer"></EMBED></OBJECT>';
} else echo 'no banners';
unset($banner);
?>

or die(mysql_error())

or die(mysql_error())