First you need a database to store your banners. We are using 2 tables; tblBanners and tblVendors:
tblBanners:
bID - auto number (banner ID)
bBanner - text (image file)
bUsedViews - number (# of views the banner has received)
bTotalViews - number (# of impressions the vendor has paid for)
bClicks - number (# of clicks the banner has received)
bURL - text (URL of the site)
bShow - yes/no (used to show and hide banners)
vID - number (vendor ID)
tblVendors:
vID - autonumber (vendor ID - links to tblBanne...[ 查看全文 ]