Random Advertising Banner Rotation
Advertising banners are the highway billboards of the web. The implementation of banners has been greatly simplified in iHTML. This example will discuss how to display a random banner every time a page is loaded.

 
Table Set-up

Have a database table set up with information relating to the advertiser. Since we use iRANDOM for this example, the table must contain an id, weight, and output field. The weight value influences the chances of a banner being displayed (consider it a ratio), which is a useful feature for the implementation of variable advertising prices. For this example, we will use the image file name for the output. We will also have fields for the destination URL, and the number of times that graphic has been viewed (a useful reporting figure).

id weight output URL Hits 1 1 inline.gif http://www.inline.net 62 2 1 ihtml.gif http://www.ihtml.com 59

 
Example (reload the page to test)

382
Unable to connect to ODBC datasource

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified @ Error Connecting to Datasource