|
<%
accessdb=server.mappath("./database/fljobs.mdb")
strconn = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE="
strconn=strconn & accessDB & ";"
set rs1=server.CreateObject("ADODB.Recordset")
rs1.Open "select top 5 * from jobs order by id desc",strconn,1,2
%>
Browse job ads
Posted date
Position
Experience
Location
Qualification
<% i= 1 %>
<% while not rs1.eof %>
<% if i= 1 or i=3 or i=5 then %>
<%=rs1(12)%>
<%=rs1(6)%>
<%=rs1(4)%>
<%=left(rs1(8),50)%>
<% else %>
<%=rs1(12)%>
<%=rs1(6)%>
<%=rs1(4)%>
<% end if %>
<% i= i+1 %>
<% rs1.movenext %>
<% wend %>
|
|