
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 tblBanners.vID)vName - text (Vendor's name)etc..........Now that the database is set up, we need to randomly d..
|