View Single Post
  #2 (permalink)  
Old April 9th, 2006, 07:09 PM
mat41 mat41 is offline
Friend of Wrox
Points: 6,664, Level: 34
Points: 6,664, Level: 34 Points: 6,664, Level: 34 Points: 6,664, Level: 34
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2004
Location: Sydney, NSW, Australia.
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

try this"



<%
 SQL = "SELECT * from lookatusnow ORDER BY [date] DESC"
 Set objRS = objConn.Execute(SQL)
 %>
<table width="600" height="100%" border="0" align="center" cellpadding="0" cellspacing="10">
<tr>
 <td colspan="2" align="left" valign="top"><p align="left"><span class="redHeading16">Look At Us Now! </span><span class="bodyblack1"><br></span></p></td>
</tr>
<tr align="left">
 <td colspan="2" valign="top"><p>Click the images to see how they are doing now! </p>
<% if not objrs.Eof then
       DO WHILE NOT objRS.EOF %>
          <p><strong>
<% IF objRS("doc") <> "" THEN %>
             <a href="<%=objRS("doc")%>" target="_blank">
<% END IF %>
          <%=response.wriye objRS("title")%> (<%=objRS("date")%>) <br>
          <img src="<%=objRS("image")%>" width="250" height="250" border="0"><% IF objRS("doc") <> "" THEN %></a><% END IF %></strong></p>
<% objRS.MoveNext %>
<% LOOP
    else
       response.write "<i>your recordset is emptu"</i>
    end if%>
 </td>
</tr>
</table>


Wind is your friend
Matt