<html>
<body bgcolor="White">
<h1 align="center">KÝTAP TABLOSU</h1>
<form action="liste.asp" method="post">
<%
set conn = Server.CreateObject("ADODB.Connection")
conn.Open "kitapdb"
Sqlliste="select * from kitap"
set rsliste = conn.Execute(Sqlliste)
%>
<table align="center" border="1">
<%
rsliste.movefirst 
while not rsliste.eof
Sqlyazar="select * from yazar where yazar_id="& rsliste("yazar_id") &""
set rsyazar = conn.Execute(Sqlyazar)
Sqlyayinevi="select * from yayinevi where yayinevi_id="& rsliste("yayinevi_id") &""
set rsyayinevi = conn.Execute(Sqlyayinevi)
%>
<tr>
<td><%=rsliste("kitap_adi")%></td>
<td><%=rsyazar("yazar_adi")%></td>
<td><%=rsyayinevi("yayinevi_adi")%></td>
<td><%=rsliste("sayfa")%></td>
<td><a href="guncelle.asp?id=<%=rsliste("kitap_id")%>&yayinevi_id=<%= rsliste("yayinevi_id") %>&yazar_id=<%= rsliste("yazar_id") %>">Degistir</a></td>
<td><a href="sil.asp?id=<%=rsliste("kitap_id")%>">Sil</a></td>
</tr>
<%
rsliste.movenext
wend
%>
</table>
</form>
</body>
</html>