<% set rs=server.createobject("adodb.recordset") sql="select top 6 * from taiyang where type='Our people' order by articleid desc" rs.open sql,conn,3,4 %> <% do while not rs.eof %> <% rs.movenext loop %>

Our people	More
<%=rs("title")%> (<%=rs("dateandtime")%>)

<% set rs=server.createobject("adodb.recordset") sql="select top 6 * from taiyang where type='Exhibition' order by articleid desc" rs.open sql,conn,3,4 %> <% do while not rs.eof %> <% rs.movenext loop %>

Exhibition	More
<%=rs("title")%> (<%=rs("dateandtime")%>)

<% set rs=server.createobject("adodb.recordset") sql="select top 6 * from taiyang where type='Products' order by articleid desc" rs.open sql,conn,3,4 %> <% do while not rs.eof %> <% rs.movenext loop %>

Products	More
<%=rs("title")%> (<%=rs("dateandtime")%>)