Баннеропоказ в форуме

<?
$banner =
$hostname = "###";
$username = "###";
$password = "###";
$dbName = "###";
$adminmail = "###";
$link = mysql_connect($hostname, $username, $password);
mysql_select_db($dbName, $link);

$zone='fz1';
$query="SELECT * FROM categoria_banner_zone WHERE zone = '$zone'";
$result=mysql_query($query);
$row=mysql_fetch_array($result, MYSQL_NUM);

$zone_id=$row[0];
$banner_n=$row[2];

if ($banner_n <=9){
$query2="SELECT * FROM categoria_banner WHERE zona = $zone_id AND banner_n = $banner_n";
$result2=mysql_query($query2);
$row2=mysql_fetch_array($result2, MYSQL_NUM);
$view=$row2[3];
$view_stop=$row2[4];
$view_new=$view+1;
if($view < $view_stop){
echo "<a href=\"/redirect.php?banner=$row2[0]\" target=_blank><img src=\"/banners/$row2[1]\"></a>";
$bannern=$banner_n+1;
$query = "UPDATE categoria_banner_zone SET banner_next ='$bannern' WHERE zone = '$zone'";
$result=mysql_query($query);
$query2="UPDATE categoria_banner SET view ='$view_new' WHERE id = '$row2[0]'";
$result2=mysql_query($query2);
} else {
echo "<img src=\"/banners/reserv.gif\">";
$bannern=$banner_n+1;
$query = "UPDATE categoria_banner_zone SET banner_next ='$bannern' WHERE zone = '$zone'";
$result=mysql_query($query);
}
} else{
$query2="SELECT * FROM categoria_banner WHERE zona = $zone_id AND banner_n = $banner_n";
$result2=mysql_query($query2);
$row2=mysql_fetch_array($result2, MYSQL_NUM);
$view=$row2[3];
$view_stop=$row2[4];
$view_new=$view+1;
if ($view < $view_stop){
$banner_n=10;
$query="SELECT * FROM categoria_banner WHERE zona = $zone_id AND banner_n = '$banner_n'";
$result=mysql_query($query);
$row=mysql_fetch_array($result, MYSQL_NUM);
echo "<a href=\"/redirect.php?banner=$row[0]\" target=_blank><img src=\"/banners/$row[1]\"></a>";
$bannern=1;
$query = "UPDATE categoria_banner_zone SET banner_next ='$bannern' WHERE zone = '$zone'";
$result=mysql_query($query);
$query2="UPDATE categoria_banner SET view ='$view_new' WHERE id = '$row2[0]'";
$result2=mysql_query($query2);
} else {
echo "<img src=\"/banners/reserv.gif\">";
$query = "UPDATE categoria_banner_zone SET banner_next ='1' WHERE zone = '$zone'";
$result=mysql_query($query);
}
};
?>