\"locked\" order by impressions asc";
$result = mysql_query($query);
$bannercount=1;
$counter=0;
while ($row = mysql_fetch_array($result)) { //start while loop
extract($row);
if($bannercount==1){
$sqlcall2 = "update banners set impressions = impressions + 1 where bannerkey = $bannerkey";
$result2 = mysql_query($sqlcall2);
$bannercount=2;
}
if ($adtype=="dblclick") { //a dblclick ad
$newUrl = $hrefurl . $dblclickid . "?";
$newImage = $imgsrcurl . $dblclickid . "?";
$updatedblclickid = "update sidebanners set dblclickid = dblclickid + 1 where bannerkey = $bannerkey";
$result3 = mysql_query($updatedblclickid);
$counter=$counter+1;
$bannerarray.= "var banner$counter = '![](\"$newImage\")
![](\"/graphics/spacer.gif\")
'\n";
} else {//not a dblclick ad
$counter=$counter+1;
$bannerarray .= "var banner$counter = '![](\"$imgsrcurl\")
'\n";
}
}//end while loop
//new for the 360x240
$select = "select * from sidebanners where width=360 and height=240 and adtype not like \"locked\" order by arraycounter limit 1";
$result = mysql_query($select);
$bannerkey=mysql_result($result, $j, "bannerkey");
$imgsrcurl=mysql_result($result, $j, "imgsrcurl");
$hrefurl=mysql_result($result, $j, "hrefurl");
$sqlcall = "update sidebanners set impressions = impressions + 1 where bannerkey = $bannerkey";
$result = mysql_query($sqlcall);
$sqlcall = "update sidebanners set arraycounter = arraycounter + 1 where bannerkey = $bannerkey";
$result = mysql_query($sqlcall);
$bigbanner .= "var bigbanner = '
'\n";
echo $bannerarray;
echo $bigbanner;
?>