$db = mysql_connect("localhost", "enzyme", "karma");
mysql_select_db("gtimes",$db);
$query = "select bannerkey, imgsrcurl, hrefurl, adtype, dblclickid from banners where adtype <> \"locked\" order by impressions asc";
$result = mysql_query($query);
$bannerkey=mysql_result($result, $j, "bannerkey");
$imgsrcurl=mysql_result($result, $j, "imgsrcurl");
$hrefurl=mysql_result($result, $j, "hrefurl");
$adtype=mysql_result($result, $j, "adtype");
$dblclickid=mysql_result($result, $j, "dblclickid");
$sqlcall = "update banners set impressions = impressions + 1 where bannerkey = $bannerkey";
$result = mysql_query($sqlcall);
if ($adtype =="dblclick") {
$newUrl = $hrefurl . $dblclickid . "?";
$newImage = $imgsrcurl . $dblclickid . "?";
$updatedblclickid = "update banners set dblclickid = dblclickid + 1 where bannerkey = $bannerkey";
$result = mysql_query($updatedblclickid);
$bannerarray= "
";
} else {
$bannerarray= "
";
}
$jsheader="function display468(){";
$jsfooter="}";
echo $jsheader;
echo "document.write(\"$bannerarray\")";
echo $jsfooter;
?>