Paging Prev-Next

C

{ CrossFire }

Hi.
First I am English a little :).
My Problem:
I want to paging this page with MS Access.But i don't it.How to do paging my
code.Thanks everybody already now.

My Codes:
Note : This is an include file.
<%
if request.QueryString("CatID")<>"" then
set rs = conn.execute("Select * From urunler Where CategoryID=" &
request.QueryString("CatID"))
end if
%>
<table style="width:520px;" cellspacing="0" cellpadding="0" align="right">
<tr>
<td class="uyeback">TEST</td>
</tr>
<tr>
<td class="dotbar" style="background-color:#FFF"></td>
</tr>
<tr>
<td>
<!--Dönen Tablo -->
<table cellpadding="0" cellspacing="0" style="width:520px;">
<tr>
<td style="background-color:#DDE6EC;height:5px;padding-left:10px;">Alt
Kategoriler</td>
</tr>
<tr>
<td class="dotbar" style="background-color:#FFF;height:5px;"></td>
</tr>
</table>
<!--Dönen Tablo -->
</td>
</tr>
<tr>
<td style="background-color:#FF6600;height:17px;"></td>
</tr>
<tr>
<td class="dotbar"></td>
</tr>
<tr>
<td>
<table cellpadding="0" cellspacing="0" style="width:520px;">
<tr>
<td style="background-color:#F2F2F2;height:20px;text-align:center;">
Page : previous | next</td>
</tr>
<tr>
<td class="dotbar" style="background-color:#FFF;height:5px;"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td style="background-image:url('images/dot_bg.gif');height:11px;"></td>
</tr>
<tr>
<td>
<!-- Dönen Tablo 2 -->
<%
iCount = 0
Do while not rs.eof
If Eval(iCount\2 = iCount/2) Then 'determine if the number is odd or even
%>
<table style="width:520px;" cellspacing="0" cellpadding="0">
<tr>
<td>

<table cellpadding="0" cellspacing="0" style="width:520px;">
<tr>
<td style="vertical-align:top;">
<table style="background-color:#f2f2f2;border:0px;width:250px;"
cellpadding="8" cellspacing="5">
<tr>
<td style="background-color:#ffffff">
<table align="center" style="background-color:#ffffff;width:220px;"
cellpadding="0" cellspacing="0">
<tr>
<%if rs("urunkresim")<>"" then%>
<td style="vertical-align:top; width:90px;">
<a href="#">
<img src="<%=rs("urunkresim")%>" style="border:0px; width:80px;height:80px;"
alt=""/></a>
</td>
<%end if%>
<td style="vertical-align:top; width:130px;">
<table cellpadding="0" cellspacing="0" style="width:130px;">
<tr>
<td class="headergreen"><%=rs("urunadi")%></td>
</tr>
<tr>
<td
style="background-image:url('images/dot_bar.gif');height:5px;"></td></tr>
<tr>
<td><%=rs("urunkisayazi")%></td></tr><tr>
<td
style="background-image:url('images/dot_bar.gif');height:5px;"></td></tr>
<tr><td>
<table cellpadding="0" cellspacing="0" style="width:130px;">
<tr><td><a href="#">
<img src="images/detay.gif" style="border:0px;" alt=""/></a></td>
</tr>
</table></td>
</tr>
<tr>
<td style="height:5px; background-image:url('images/dot_bar.gif');">
</td>
</tr>
<tr>
<td>
<table cellpadding="0" cellspacing="0" style="width:130px">
<tr>
<td class="price">Fiyatý : <%=rs("urunfiyat")%> YTL</td></tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</td>
<td style="width:20px;"></td>
<%ELSE%>
<td style="vertical-align:top;">
<table style="background-color:#f2f2f2;border:0px;width:250px;"
cellpadding="8" cellspacing="5">
<tr>
<td style="background-color:#ffffff">
<table align="center" style="background-color:#ffffff;width:220px;"
cellpadding="0" cellspacing="0">
<tr>
<%if rs("urunkresim")<>"" then%>
<td style="vertical-align:top; width:90px;">
<a href="#">
<img src="<%=rs("urunkresim")%>" style="border:0px; width:80px;height:80px;"
alt=""/></a>
</td>
<%end if%>
<td style="vertical-align:top; width:120px;">
<table cellpadding="0" cellspacing="0" style="width:130px;">
<tr>
<td class="headergreen"><%=rs("urunadi")%></td>
</tr>
<tr>
<td
style="background-image:url('images/dot_bar.gif');height:5px;"></td></tr>
<tr>
<td><%=rs("urunkisayazi")%></td></tr><tr>
<td
style="background-image:url('images/dot_bar.gif');height:5px;"></td></tr>
<tr><td>
<table cellpadding="0" cellspacing="0" style="width:130px;">
<tr><td><a href="#">
<img src="images/detay.gif" style="border:0px;" alt=""/></a></td>
</tr>
</table></td>
</tr>
<tr>
<td style="height:5px; background-image:url('images/dot_bar.gif');">
</td>
</tr>
<tr>
<td>
<table cellpadding="0" cellspacing="0" style="width:130px">
<tr>
<td class="price">Fiyatý : <%=rs("urunfiyat")%> YTL</td></tr>
</table></td></tr></table></td></tr></table></td></tr></table>
</td></tr></table>
</td>
</tr>
<tr>
<td
style="background-image:url('images/dot_bg.gif');height:11px;"></td></tr>
<%
End If
iCount = iCount +1 'increment the counter

rs.movenext
loop
response.write "</table>"
%> </table>

<!-- Dönen Tablo 2 -->
</td>
</tr>
<tr>
<td>
<table cellpadding="0" cellspacing="0" style="width:520px;">
<tr>
<td style="background-color:#FFF">&nbsp;</td>
</tr>
<tr>
<td
style="background-color:#F2F2F2;height:20px;text-align:center;">Sayfa
: | 1 |</td>
</tr>
<tr>
<td class="dotbar" style="background-color:#FFF;height:5px;"></td>
</tr>
</table></td>
</tr>
<tr>
<td style="background-image:url('images/dot_bg2.gif');height:21px;"></td>
</tr>
</table>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,767
Messages
2,569,570
Members
45,045
Latest member
DRCM

Latest Threads

Top