<% Set rs = Server.CreateObject("ADODB.Recordset") rsql="SELECT * FROM tblNews where News_Approve='Yes' Order by SlNo Desc" rs.Open rsql,con,1,3 %>

<%if rs.EOF then%> <%else%> <%while not rs.eof%> <% rs.movenext wend end if %> Sorry....No News at present... <%=rs("News_Heading")%> <%Response.Write(rs("News_Content"))%> Posted on : <%=formatdatetime((rs("News_Date")),vblongdate)%>
Powered by Nissi Infotech