<% Set objRS = Server.CreateObject("ADODB.Recordset") sQuery = "SELECT * FROM tbl_newsdetails WHERE News_category_id = "& sCategory_id &" ORDER BY News_id DESC" set objRs = connobj.execute(sQuery) if not objRs.eof then %> <% do while not objRS.eof %> "> <% response.write objRS("News_title") %> <% objRS.movenext loop %> <% end if %>

Back