|
|
<% if pagename="gulenelma" then %>
 |
|
<%
sql=" SELECT * FROM TV WHERE ID IN (SELECT MAX(ID) FROM TV)"
objRS.open sql,objCN,1,3
%>
<% objRS.close %>
|
 |
|
<% else %>
<%end if%>
<%%>
<%%>
<%%>
<%%>
|
 |
|
Reklam dünyası ile ilgili
gözünüze batan ve dile getirmek istediğiniz
herşeyi burada yazıya dökebilirsiniz.
|
 |
<%
sql=" SELECT G.SUBJECT AS SUBJECT,G.CONTENT AS CONTENT,G.REG_DATE AS REG_DATE,C.USERNAME AS USERNAME FROM GOZ AS G,CUSTOMERS AS C WHERE G.CID=C.ID AND ISPUBLISH=1 ORDER BY G.REG_DATE DESC"
objRS.open sql,objCN,1,3
if not objRS.eof then
%>
<%
maxPageCap=10
if trim(request.querystring("page"))="" then
curpage=1
else
curPage=cint(trim(request.querystring("page")))
end if
recCo=objRs.recordcount
x=(curpage-1)*maxPageCap
if x>recCo then
response.write "hata"
response.end
end if
objRs.move x
co=0
co1=(curPage-1)*maxPageCap
%>
<%
while not objrs.eof and co
<%=objRS("SUBJECT")%>
|
<%=objRS("CONTENT")%>
|
| Tarihi: <%=objRS("REG_DATE")%>,
İddia Sahibi: <%=objRS("USERNAME")%>
|
|
|
<%
co=co+1
co1=co1+1
objRS.movenext
wend%>
<%end if%>
|
|
|
|
 |