|
<%set rs=server.createobject("adodb.recordset")
rs.open "haber where sondakika=true and koseyazisi=false and haberonay='Evet' order by tarih desc",cilem,1,3
kayitsayisi = rs.recordcount%>
| tema/<%=tema%>/genelustbar.gif<%Else%>tema/<%=tema%>/sondakikabg.gif<% end if%>">
|
<%katid= request("katid")
set rs3=server.createobject("adodb.recordset")
rs3.open "haber where mansethaber=true and koseyazisi=false and katid=" & guvenlik(request("katid"))& " and haberonay='Evet' order by tarih desc",cilem,1,3
mansetkayitsayisi= rs3.recordcount%>
<%if mansetkayitsayisi="" or mansetkayitsayisi="0" then %>
<%Else%>
 |
Yükleniyor... |
|
<%
yeni = Request.QueryString("yeni")
If yeni="" Then yeni=1
rs3.pagesize = mansetsayisi
rs3.absolutepage = yeni
yeni_sayfa = rs3.pagecount
for i=1 to rs3.pagesize
if rs3.eof then
exit for
end if
%>
<%manset = manset + 1%><%
rs3.movenext
Next
%>
<%katid= request("katid")
set rs3=server.createobject("adodb.recordset")
rs3.open "haber where mansethaber=true and koseyazisi=false and katid=" & guvenlik(request("katid"))& " and haberonay='Evet' order by tarih desc",cilem,1,3
mansetkayitsayisi= rs3.recordcount%>
<%
yeni = Request.QueryString("yeni")
If yeni="" Then yeni=1
rs3.pagesize = mansetsayisi
rs3.absolutepage = yeni
yeni_sayfa = rs3.pagecount
for i=1 to rs3.pagesize
if rs3.eof then
exit for
end if
%>
|
tema/<%=tema%>/mansetresimyok.gif<% else %><%if rs3("resimsec")="Url" then %><%=rs3("resimurl")%><% else %>resim/<%=rs3("resim")%><% end if%><% end if%>" width="220" hspace="1" vspace="1" style="border: 1px solid #C0C0C0"> |
|
<%=rs3("baslik")%> |
|
<%=rs3("kisahaber")%>
|
<%mansetsira = mansetsira + 1%><%
rs3.movenext
Next
%>
<%end if%>
|
<%set rs2=server.createobject("adodb.recordset")
rs2.open "kategori",cilem,1,3
%>
<%
ayir=2
Dim l
l= 0
do while l < 4 and not rs2.eof
%>
<%
Dim kategoriler
kategoriler = 0
do while kategoriler < ayir and NOT rs2.eof
%>
| "><%=rs2("kategoriadi")%>
¬ |
<%katid=rs2("katid")%>
<%Set rs = cilem.Execute("Select * from haber where koseyazisi=false and katid ="&rs2("katid")&" and haberonay='Evet' order by bolum desc")
If not rs.eof then%>
<%Set basliksay = cilem.Execute("Select count(bolum) from haber where koseyazisi=false and katid=" & katid& "and haberonay='Evet' ")
basliksayisi = rs.recordcount%>
<%If basliksay(0) > 5 then verisay = 4 else verisay = basliksay(0)
basliksay.close%>
<%For i = 1 to verisay
If i = 1 then %>
<% else%>
<%
end if
rs.movenext
next
End If
rs.close %>
|
|
<%
rs2.Movenext
kategoriler = kategoriler + 1
loop
%>
<%
l=2+1
loop%>
|
|
|
|
|