Press Release

<% Set objRS = Server.CreateObject("ADODB.Recordset") sQuery = "SELECT TOP 3 News_id, News_title FROM tbl_newsdetails WHERE News_category_id = 1 ORDER BY News_id DESC" set objRs = connobj.execute(sQuery) if not objRs.eof then %>
<% end if %>
In the News
<% Set objRS = Server.CreateObject("ADODB.Recordset") sQuery = "SELECT TOP 3 News_id, News_title FROM tbl_newsdetails WHERE News_category_id = 2 ORDER BY News_id DESC" set objRs = connobj.execute(sQuery) if not objRs.eof then %>
<% end if %>
Articles
<% Set objRS = Server.CreateObject("ADODB.Recordset") sQuery = "SELECT TOP 3 News_id, News_title FROM tbl_newsdetails WHERE News_category_id = 3 ORDER BY News_id DESC" set objRs = connobj.execute(sQuery) if not objRs.eof then %>
<% end if %>
Events
<% Set objRS = Server.CreateObject("ADODB.Recordset") sQuery = "SELECT TOP 3 News_id, News_title FROM tbl_newsdetails WHERE News_category_id = 4 ORDER BY News_id DESC" set objRs = connobj.execute(sQuery) if not objRs.eof then %>
<% end if %>
Awards
<% Set objRS = Server.CreateObject("ADODB.Recordset") sQuery = "SELECT TOP 3 News_id, News_title FROM tbl_newsdetails WHERE News_category_id = 5 ORDER BY News_id DESC" set objRs = connobj.execute(sQuery) if not objRs.eof then %>
<% end if %>
       
       
       
       
       
© 2007 Pricol Packaging Ltd
Legal Disclaimer | Privacy Policy