arkadaşlar emlak sitemde arama kısmı yaptım.
tek sonuç tümünü gösterme seçeneğini aktif edemedim.
kodları veriyorum bir gös atarmısınız acaba.
arama sayfası: <form method="POST" action="aramasonuclari.asp" target="_top" onSubmit="return check_frmm()" name="kontrol">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="11%" id="AutoNumber1" height="136">
<tr>
<td width="100%" align="center" height="20"><font face="Verdana">
<span style="font-style: normal; font-weight:700"><font size="1">
<img border="0" src="images/bullet.gif" width="8" height="7"> Emlak
Türü </font></span></td>
</tr>
<tr>
<td width="100%" align="center" height="27"><font face="Verdana" size="1">
<select name="tur" size="1" style="font-family : Verdana; font-size : 8pt; font-weight: bold; color:#000000; background-color:#FFFAF2">
<option>Seçim Yapınız</option>
<%
set rs = server.createobject("adodb.recordset")
sql = "select * from tur"
rs.open sql, conn, 1, 3
%>
<% DO WHILE NOT rs.EOF %>
<option value="<%=rs("mahalle")%>"><%=rs("mahalle")%></option>
<%
rs.MoveNext
LOOP
%>
<option value="hepsi">Tümünü Göster</option>
</select></font></td>
</tr>
<tr>
<td width="100%" align="center" height="18"><font face="Verdana">
<span style="font-style: normal; font-weight:700"><font size="1">
<img border="0" src="images/bullet.gif" width="8" height="7">
Yerleşim yeri </font></span></td>
</tr>
<tr>
<td width="100%" align="center" height="24"><font face="Verdana" size="1">
<select name="yer" size="1" style="font-family : Verdana; font-size : 8pt; font-weight: bold; color:#000000; background-color:#FFFAF2">
<option>Seçim Yapınız</option>
<%
set rs = server.createobject("adodb.recordset")
sql = "select * from mahalleler"
rs.open sql, conn, 1, 3
%>
<% DO WHILE NOT rs.EOF %>
<option value="<%=rs("mahalle")%>"><%=rs("mahalle")%></option>
<%
rs.MoveNext
LOOP
%>
<option value="hepsi">Tümünü Göster</option>
</select></td>
</tr>
<tr>
<td width="100%" align="center" height="19"><font face="Verdana">
<span style="font-style: normal; font-weight:700"><font size="1">
<img border="0" src="images/bullet.gif" width="8" height="7"> </font></span>
<font size="1"><span style="font-weight: 700">Kategoriler </span></font></td>
</tr>
<tr>
<td width="100%" align="center" height="24"><font face="Verdana" size="1">
<select name="kategori_id" size="1" style="font-family : Verdana; font-size : 8pt; font-weight: bold; color:#000000; background-color:#FFFAF2">
<option>Seçim Yapınız</option>
<%
set rs = server.createobject("adodb.recordset")
sql = "select * from kategori"
rs.open sql, conn, 1, 3
%>
<% DO WHILE NOT rs.EOF %>
<option value="<%=rs("id")%>"><%=rs("kategori_adi")%></option>
<%
rs.MoveNext
LOOP
%>
<option value="hepsi">Tümünü Göster</option>
</select></td>
</tr>
<tr>
<td width="100%" height="27" align="center">
<p align="center">
<input type="submit" value="Aramaya Başla" name="B1" style="border:2px dotted #FFFFFF; font-size: 8pt; font-family: Verdana; font-weight: bold; background-color: #0069AA; float:left; color:#FFFFFF"></td>
</tr>
</table>
</form>
arama sonuç sayfası: <%
tur = request.form("tur")
yer = request.form("yer")
%>
<!--#include file = "genelayarlar.asp"-->
<%
Set ayarlar = Server.CreateObject("Adodb.RecordSet")
sql_ayarlar = "Select * from ayarlar"
ayarlar.open sql_ayarlar,bag,1,3
%>
<SCRIPT LANGUAGE="JavaScript">
<!-- Begin
function OpenImage(img){
foto1= new Image();
foto1.src=(img);
Controlla(img);
}
function Controlla(img){
if((foto1.width!=0)&&(foto1.height!=0)){
viewFoto(img);
}
else{
funzione="Controlla('"+img+"')";
intervallo=setTimeout(funzione,20);
}
}
function viewFoto(img){
largh=foto1.width+20;
altez=foto1.height+20;
stringa="width="+largh+",height="+altez;
finestra=window.open(img,"",stringa);
}
// End -->
</script>
<HTML>
<HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1254">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<TITLE><%=ayarlar("Siteadi")%></TITLE>
<meta http-equiv="Content-Language" content="tr">
<LINK
href="site_dosyalar/magic_ie.css" type=text/css rel=stylesheet>
</HEAD>
<BODY bgColor=#eff0ec leftMargin=0 topMargin=0 onload=preloadImages();
marginheight="0" marginwidth="0" background="images/arka.JPG">
<CENTER>
<TABLE cellSpacing=0 cellPadding=0 border=0 height="452" width="382" style="border-collapse: collapse" bordercolor="#111111">
<TBODY> <TR height=170>
<TD align=middle width="889" height=194>
<TABLE height=169 cellSpacing=0 cellPadding=0 width=751
border=0 style="border-collapse: collapse" bordercolor="#111111">
<!-- #include file="ust.asp" -->
<TR>
<TD width=889 height=137>
<div align="center">
<center>
<TABLE cellSpacing=0 cellPadding=0 width=760 border=0 height="568" style="border-collapse: collapse" bordercolor="#111111">
<TBODY>
<TR>
<!--#include file = "sol.asp"-->
<TD width=10 height="568"><IMG height=1 src="site_dosyalar/spacer.gif"
width=10></TD>
<TD vAlign=top width=566 height="568">
<TABLE height=1 cellSpacing=0 cellPadding=0 width=523 border=0>
<TBODY>
<TR>
<TD width="590" background=site_dosyalar/menu_zem.gif
height=2>
<TABLE height=39 cellSpacing=0 cellPadding=0 width="566"
border=0 style="border-collapse: collapse" bordercolor="#111111">
<TBODY>
<TR>
<TD width="8"><IMG height=39
width=1></TD>
<TD align=middle width="551" height=39>
<TABLE height=39 cellSpacing=0 cellPadding=0
width="554" border=0>
<TBODY>
<TR>
<TD align=middle width=29 height=39><IMG height=17
alt=Name src="site_dosyalar/ico_person.gif"
width=17></TD>
<TD align=left width="404"
height=39><font color="#FFFFFF"><b>Arama Sonuçları</b></font></TD>
<TD align=left width="121"
height=39>
</script>
<center>
</p>
</TD>
</TR></TBODY></TABLE></TD>
<TD width="7"> </TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD width=590 height=10><IMG height=3
src="site_dosyalar/spacer.gif" width=1></TD></TR>
<TR>
<TD vAlign=top width=590 height="1">
<TABLE cellSpacing=0 cellPadding=0 width=566 bgColor=#ffffff
border=0 height="1">
<TBODY>
<TR>
<TD width=1 bgColor=#d8dcd9 height="5"><IMG height=1 alt=""
src="site_dosyalar/spacer.gif" width=1></TD>
<TD align=right
background=site_dosyalar/info_main_top_bg.gif
colSpan=2 width="564" height="5"><IMG height=5 alt=""
src="site_dosyalar/info_corner_top.gif" width=5></TD></TR>
<TR>
<TD width=1 bgColor=#d8dcd9 height="1"><IMG height=1 alt=""
src="site_dosyalar/spacer.gif" width=1></TD>
<TD width=565 height="1" valign="top" align="center">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber7" height="176">
<tr>
<td width="100%" align="center" valign="top" height="176">
<html><body><div align="center" style="width: 560; height: 167">
<table border="0" width="558" id="table1" cellpadding="0" height="164" style="border-collapse: collapse" align="left" cellspacing="0">
<tr>
<td width="253" style="border:2px dotted #EFF0EC; " align="left" height="29" background=site_dosyalar/menu_zem.gif>
<p align="center">
<span style="font-style: normal; font-weight: 700">
<font size="1" face="Verdana" color="#FFFFFF">Emlak Türü</font></span></td>
<td style="border:2px dotted #EFF0EC; " width="54" align="left" height="29" background=site_dosyalar/menu_zem.gif>
<p align="center">
<font face="Verdana" style="font-weight:700; font-size:8pt">
</font><font face="Verdana" style="font-weight:700; " size="1" color="#FFFFFF">Yerleşim</font></td>
<td width="27" style="border:2px dotted #EFF0EC; " align="left" height="29" background=site_dosyalar/menu_zem.gif>
<p align="center"><b><font size="1" face="Verdana" color="#FFFFFF">Hit</font></b></td>
<td width="97" style="border:2px dotted #EFF0EC; " align="left" height="29" background=site_dosyalar/menu_zem.gif>
<p align="center"><span style="font-weight: 700">
<font face="Verdana" style="font-size: 8pt" color="#FFFFFF">Fiyat</font></span></td>
<td width="95" style="border:2px dotted #EFF0EC; " align="left" height="29" background=site_dosyalar/menu_zem.gif>
<p align="center"><span style="font-weight: 700">
<font face="Verdana" style="font-size: 8pt" color="#FFFFFF">Emlak Resmi</font></span></td>
</tr>
<%
SQL = "SELECT * FROM ilanlar"
SQL = SQL & " WHERE (ilanlar.tur = '" & tur & "') and (ilanlar.yer like '" & yer & "')"
VT_YOL = SERVER.MAPPATH("db/deltaxemlak213.mdb")
DSN = "DBQ=" & VT_YOL & ";Driver={Microsoft Access Driver (*.mdb)}"
Set BAGLANTI = Server.CreateObject("ADODB.Connection")
BAGLANTI.Open DSN
set rs = server.createobject("ADODB.Recordset")
rs.open SQL,BAGLANTI,1,3
if rs.eof then %>
<tr>
<td width="256" height="19" background="ortaorta.PNG" valign="top"> </td></tr>
<tr>
<td align="center" width="256" height="84" background="ortaorta.PNG" valign="top">
<font color="#000000" size="2" face="Arial"><b>Aradığınız Kriterlere Uygun
Kayıtlı İlan Bulunamadı.</b></font><p>
<font color="#999999" size="2" face="Arial">
<a href="javascript:history.go(-1);">Geri </a></font></td></tr>
<tr>
<td width="256" height="19" background="ortaorta.PNG" valign="top"> </td></tr>
<% else %>
<%do while not Rs.Eof%>
<tr>
<td width="253" style="border-style:dotted; border-width:2; " align="center" height="13">
<b>
<font face="Verdana" size="1" color="#FFFFFF">
<img border="0" src="images/bullet.gif"> </font><span style="text-transform: uppercase"><font face="Verdana" size="1" color="#FFFFFF">
</font></span>
<font face="Arial" size="1" color="#FFFFFF">
<A onclick="window.open('detaylar.asp?id=<%=rs("id")%>','new', 'toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no, resizable=no,copyhistory=no,width=810,height=715'); return false;"
href="detaylar.asp?id=<%=rs("id")%>" style="text-decoration: none; ">
<font color="#000000" face="Verdana">
<% = Left(rs("tur"),14) %><span style="text-transform: uppercase"> </span> </font>
</a></b></td>
<td style="border-style:dotted; border-width:2; " width="54" align="center" height="13">
<b>
<font face="Verdana" size="1" color="#FFFFFF">
<img border="0" src="images/bullet.gif"> </font><span style="text-transform: uppercase"><font face="Verdana" size="1" color="#FFFFFF">
</font></span>
<font face="Arial" size="1" color="#FFFFFF">
<A onclick="window.open('detaylar.asp?id=<%=rs("id")%>','new', 'toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no, resizable=no,copyhistory=no,width=810,height=715'); return false;"
href="detaylar.asp?id=<%=rs("id")%>" style="text-decoration: none; ">
<font color="#000000" face="Verdana">
<% = Left(rs("yer"),14) %><span style="text-transform: uppercase"> </span> </font>
</a></b></td>
<td width="27" style="border-style:dotted; border-width:2; " align="center" height="13">
<b>
<font face="Verdana" size="1" color="#000000">
<span style="text-transform: uppercase"><%=rs("hit")%></span></font></b></td>
<td width="97" style="border-style:dotted; border-width:2; " align="center" height="13">
<b>
<span style="text-transform: uppercase">
<font face="Verdana" size="1" color="#000000">
<%=rs("fiyat")%></font><font face="Verdana" size="1" color="#FFFFFF">.</font></span><font face="Verdana" size="1" color="#000000"><%=rs("paraturu")%> </font></b></td>
<td width="95" style="border-style:dotted; border-width:2; " align="center" height="13">
<b>
<font face="Arial" size="1" color="#000000"> </font>
</b><span style="background-color: #FFC977">
<a href="javascript:OpenImage('<%=rs("resim")%>','ik','scrollbars=no,resizable=no,width=550,height=450')">
<img src="<%=rs("resim")%>" border="2" style="; border-width:3; border-style:outset; padding-left:4; padding-right:4; padding-top:1; padding-bottom:1" hspace="1" vspace="1" alt="<%=rs("mesaj")%>" width="39" height="22"></a></span></td><%Rs.MoveNext
Loop
%>
</tr><%
Rs.Close
Set Rs = Nothing
end if
%>
</table>
<div align="left">
</div>
</div>
</body>
</html></td>
</tr>
</table>
</TD>
<TD width=1 bgColor=#d8dcd9 height="1"><IMG height=1 alt=""
src="site_dosyalar/spacer.gif" width=1></TD></TR>
<TR height=5>
<TD width=1 bgColor=#d8dcd9 height="6"><IMG height=1 alt=""
src="site_dosyalar/spacer.gif" width=1></TD>
<TD align=right
background=site_dosyalar/info_main_bottom_bg.gif
colSpan=2 width="564" height="6"><IMG height=6 alt=""
src="site_dosyalar/info_corner_bottom.gif"
width=6></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
</center>
</div>
</TD></TR>
<!-- #include file="alt.asp" -->
</BODY></HTML>