As my title states, I have what I want to work fine statically, but making it dynamic is a bit of a hassle. I have the components in place, I just don't know how to display these across.
Here's my code and I want it to look like
http://www.dvdauthority.com/newauth.asp<table width="780" class="index_column1" border="0">
<tr>
<%
'Set Conn = Server.CreateObject("ADODB
.Connectio
n")
'Conn.Open Application("inet_dvdautho
rity")
'sql = "SELECT R.title,oscar,releasedate,
title_imag
e, TR.[image], Convert(varchar(250), R.Body) + '...' AS Body, Convert(varchar(10), 'TR.[date], 101) AS [date], TR.ReviewID FROM dbo.TodaysReviews TR INNER JOIN dbo.newreviews R ON TR.ReviewID = R.ReviewID WHERE TR.[date] > 'DATEADD(day, -10, TR.[date]) AND active > 0 ORDER BY TR.sort DESC"
'Set RS = Conn.Execute(sql)
%>
<%
'iCounter = 1
Do Until RS.EOF
reviewID = RS("reviewID")
image = RS("image")
curDate = RS("date")
title = RS("title")
oscar = RS("oscar")
Body = Left(RS("body"), 125)
releasedate = RS("ReleaseDate")
title_image = RS("title_image")
%>
<%
If Not IsNull(image) And image <> "" Then%>
<td style="padding-left:15px;p
adding-bot
tom:15px;"
>
<table border="0" cellpadding="2" cellspacing="2">
<tr>
<td valign="top" width="230" bgcolor="#ffffff"><a href="/reviews.asp?reviewI
D=1234"><i
mg src="/images/notable/seren
ity_not.jp
g" border="0" height="248" width="230" alt="Serenity"></a><br />
<a href="/reviews.asp?reviewI
D=1234" class="mptitle">Serenity</
a><br />As the planet's population boomed, the world stayed the same size and sooner or later, the room was bound to run out. At that...</td>
<td width="15"> </td>
<td valign="top" width="230" bgcolor="#ffffff"><a href="/reviews.asp?reviewI
D=1234"><i
mg src="/images/notable/seren
ity_not.jp
g" border="0" height="248" width="230" alt="Serenity"></a><br /> <a href="/reviews.asp?reviewI
D=1234" class="mptitle">Serenity</
a><br />As the planet's population boomed, the world stayed the same size and sooner or later, the room was bound to run out. At that...</td>
<td width="15"> </td>
<td valign="top" width="230" bgcolor="#ffffff"><a href="/reviews.asp?reviewI
D=1234"><i
mg src="/images/notable/seren
ity_not.jp
g" border="0" height="248" width="230" alt="Serenity"></a><br /> <a href="/reviews.asp?reviewI
D=1234" class="mptitle">Serenity</
a><br />As the planet's population boomed, the world stayed the same size and sooner or later, the room was bound to run out. At that...</td>
<%
End If
%>
<%
RS.MoveNext
prevDate = curDate
Loop
RS.Close
Set RS = nothing%>
</tr></table></td></tr></t
able>
So in essence, I want it to display three things at a time (different titles of course, but that will take care of itself when the time is right) I just don't know how to code it so that I have a movie, space, movie, space, movie, space.
Start Free Trial