|
|
|
<%
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 %>
|
