<% Set db=Server.CreateObject("ADODB.Connection") db.Open "PROVIDER=MSDASQL;" & _ "DRIVER={Microsoft Access Driver (*.mdb)}; " & _ "DBQ=" & server.mappath("yonetim/db/neutral.mdb") %> <% Set rs = Server.CreateObject ("ADODB.RecordSet") sql = " Select * from kategoriler" rs.open sql,db,1,3 do while not rs.eof %> <% rs.movenext loop rs.close set rs=nothing %> <% kategori=Request.Querystring("kategori") Set Rs=Server.CreateObject("Adodb.Recordset") sorgu="select * from album where kategori = '" & kategori & "' and onay=1 ORDER BY id DESC" Rs. Open Sorgu, db, 1, 3 If rs.eof then Response.Write "Veritabanında Henüz Kayıt Yok." Response.End End If adet=rs.recordcount shf = Request.QueryString("shf") if shf="" then shf=1 end if %>


»  Ürünler & Servis / <%=kategori%>

 
 

   »  EXPRESSWELD

   »  LINCOLN ELECTRIC

   »  TORÇ ve YEDEK PARÇA

   »  DİĞER MAKİNALAR

   »  ASKAYNAK

<% rs.pagesize = 10 rs.absolutepage = shf sayfa = rs.pagecount for i=1 to rs.pagesize if rs.eof then exit for if i mod 1=1 then response.write "" end if %> <% if i=1 or i=2 or i=3 or i=4 or i=5 or i=6 or i=7 or i=8 or i=9 or i=10 or i=11 or i=12 or i=13 or i=14 or i=15 or i=16 or i=17 or i=18 or i=19 or i=20 then response.write "" end if %> <% rs.movenext %> <% if i mod 1=0 then response.write "" end if next %>

<%=rs("baslik")%>

<%=rs("fiyat")%>

">       

Kategoride <%=adet%>  Ürün Mevcut. |  Sayfa : <% for y=1 to sayfa if shf=y then response.write y else response.write " "&y&" - " end if next %>