Here's what I have so far.
In the head:
This is where the ads will display in the body:
Set rsArticles_cmd = Server.CreateObject ("ADODB.Command")
rsArticles_cmd.ActiveConnection = MM_Classifieds_STRING
rsArticles_cmd.CommandText = "SELECT * FROM AD WHERE CLASS_NUMBER = '99' ORDER BY START_DATE ASC"
rsArticles_cmd.Prepared = true
Set rsArticles = rsArticles_cmd.Execute
rsArticles_numRows = 0
Repeat1__numRows = -1
Repeat1__index = 0
rsArticles_numRows = rsArticles_numRows + Repeat1__numRows
I have an image pulling from the database but when there isn't one I need it to be nothing. And of course displaying the image in a certain place depending on the type in the image1Typ field.
<img src="<%=(rsArticles.Fields.Item("IMAGE1").Value)%>" width="32" height="32" /> <%=(rsArticles.Fields.Item("AD_TEXT").Value)%>