'0') { while($asb = mysql_fetch_array($rsb)) { $NewBannersArray[] = $asb[BannerID]; } $DisplayBannerID = array_rand($NewBannersArray); $BannerID = $NewBannersArray[$DisplayBannerID]; //get the selected banner info $qsb2 = "select * from yellow_banners where BannerID = '$BannerID' "; $rsb2 = mysql_query($qsb2) or die(mysql_error()); $asb2 = mysql_fetch_array($rsb2); echo ""; $date_now = time(); $this_ip = $_SERVER[REMOTE_ADDR]; $qsb3 = "insert into yellow_stats set BannerID = '$BannerID', impressions = '1', mydate = '$date_now', ip = '$this_ip' "; mysql_query($qsb3) or die(mysql_error()); } ?>