<% ID = TRIM( Request( "id" ) ) ' Open the Database Connection ConnString = "Driver={MySQL};SERVER=localhost;DATABASE=impactDB;UID=rrsnider;PASSWORD=rs9363" Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open ConnString sqlstring = "select Picture1, Picture2, Picture3, Picture4, BriefDesc, FullDesc, OurPrice, RetailPrice " &_ "from autos " &_ "where ID= " & ID Set RS = Server.CreateObject("ADODB.Recordset") RS.CursorType = adOpenStatic RS.ActiveConnection = Conn RS.Open sqlString %>
<% IF RS( "Picture1" ) <> "????" THEN %>
" width="240" height="192">
<% END IF %>

<%=RS("FullDesc")%>
<% IF RS( "RetailPrice" ) <> "????" THEN %>
Retail Price: $<%=RS("RetailPrice")%> <% END IF %> <% IF RS( "OurPrice" ) <> "????" THEN %>
Our Price: $<%=RS("OurPrice")%> <% END IF %>

<% IF RS( "Picture2" ) <> "????" THEN %>
" width="240" height="192">
<% END IF %> <% IF RS( "Picture3" ) <> "????" THEN %>
" width="240" height="192">
<% END IF %> <% IF RS( "Picture4" ) <> "????" THEN %>
" width="240" height="192">
<% END IF %>