merhaba arkadaşlar bir script yaptım arama kısmında hata alıyorum istediğim kriterlerde arama yapmıyor hatayı anlamadım.
arama yapılan form
<form method=post action=sonuc.php >
<div class="vacsearch">
<div class="vacsearch_in" style="background: url(/test/_resx/images/vacsearch/bg-uk.gif); #0185a8 no-repeat left top">
<h2>
</h2>
<div class="clear">
</div>
<fieldset>
<legend></legend>
<div class="col_half floatl">
<p>
<?php
echo "<form name=sel>\n";
echo "<font id=states><select >\n";
echo "<option value='0'>Sektörler (Hepsi)</option> \n" ;
echo "</select></font>\n";
?>
</p>
</div>
<div class="col_half floatr" style="width: 221px; height: 149px">
<p>
<?php
echo "<font id=cities><select style='width: 214px;'>\n";
echo "<option value='0'>Alt Sektörler (Hepsi)</option> \n" ;
echo "</select></font>\n";
?>
<script language=Javascript>
function Inint_AJAX() {
try { return new ActiveXObject("Msxml2.XMLHTTP"); } catch(e) {} //IE
try { return new ActiveXObject("Microsoft.XMLHTTP"); } catch(e) {} //IE
try { return new XMLHttpRequest(); } catch(e) {} //Native Javascript
alert("XMLHttpRequest not supported");
return null;
};
function dochange(src, val) {
var req = Inint_AJAX();
req.onreadystatechange = function () {
if (req.readyState==4) {
if (req.status==200) {
document.getElementById(src).innerHTML=req.responseText; //retuen value
}
}
};
req.open("GET", "sektor_alt_sektor.php?data="+src+"&val="+val); //make connection
req.setRequestHeader("Content-Type", "application/x-www-form-urlencoded;charset=windows-1254"); // set Header
req.send(null); //send value
}
window.onLoad=dochange('states', -1); // value in first dropdown
</script>
</p>
<p>
<select size='1' name='sehir' style='width: 214px; '>
<option selected value="">Şehirler (Hepsi)</option>
<?php
$sorgu = mysql_query('SELECT * FROM sehirler ORDER BY sehir ASC');
while ($cek = mysql_fetch_array($sorgu)) {
$sehir = $cek[sehir];
echo "<option value='$cek[sehir]' >$cek[sehir]</option>";
}
?>
</select>
</p>
<p>
<select size='1' name='is_tipi' style='width: 214px; '>
<option value="" selected>İş Türü (Hepsi)</option>
<option value="Daimi">Daimi</option>
<option value="Geçici">Geçici</option>
<option value="Sözleşmeli">Sözleşmeli</option>
</select>
</p>
<p>
<input onblur="if (this.value == '') this.value = 'Anahtar Kelime'" onfocus="if (this.value == 'Anahtar Kelime') this.value=''" size=20 value="Anahtar Kelime" name="kelime" style='width: 208px; ' >
</p>
<p>
</p>
<div class="button2 floatr">
<input type="submit" name="ctl00$MainContent$UxDefault$uxSearch" value="Ara" id="ctl00_MainContent_UxDefault_uxSearch" />
</div>
<p>
</p>
</div>
<div class="clear">
<!-- -->
</div>
</fieldset>
</div>
</div></form>sonuc.php
<table border='0' width='100%' cellspacing='0' cellpadding='0' id='table1' >
<?php
if ( $count > 0){
echo " <tr>
<td colspan='3' height='30' bgcolor='#B2E1E7'><font color='#092561'> <b>Arama Sonuçları</b></td>
</tr>
<tr>
<td height='1' width='1241' bgcolor='#FFFFFF' colspan='3'>
<font style='font-size: 1pt'> </font></td>
</tr>";
} else {
echo "<center><font color='#00A0C6'>Arama Kriterlerinize Uygun Sonuç Bulanamadı.</font></center>";
}
?>
<?php
$sorgu = mysql_query("SELECT * FROM ilanlar WHERE yayin_durumu='yayinda' AND sektorid LIKE '%$_POST[states]%' AND altsektorid LIKE '%$_POST[cities]%' AND sehir LIKE '%$_POST[sehir]%' AND is_tipi LIKE '%$_POST[is_tipi]%' AND baslik LIKE '%$_POST[kelime]%' OR ilan LIKE '%$_POST[kelime]%' ");
while ($cek = mysql_fetch_array($sorgu)) {
$id = $cek[id];
$sehir = $cek[sehir];
$is_tipi = $cek[is_tipi];
$baslik = $cek[baslik];
echo " <tr>
<td height='30' width='1157' colspan='2' bgcolor='#F9F9F9'> <a href='ilan.php?id=$cek[id]'><font color='#092561'><b>$cek[baslik]</b></font></a></td>
<td height='19' width='84' bgcolor='#F9F9F9'><a href='sepete_ekle.php?id=$cek[id]'><img src='../_resx/images/sepete_ekle.png'></a></td>
</tr>
<tr>
<td height='20' width='280' bgcolor='#F9F9F9'><font color='#00A0C6'> Şehir :</font> $cek[sehir]</td>
<td height='20' width='877' bgcolor='#F9F9F9'><font color='#00A0C6'></td>
<td width='84' bgcolor='#F9F9F9'>
<a href='basvur.php?id=$cek[id]'><img src='../_resx/images/basvur.png'></a></td>
</tr>
<tr>
<td height='20' width='280' bgcolor='#F9F9F9'><font color='#00A0C6'> İş Tipi :</font> $cek[is_tipi]</td>
<td height='20' width='877' bgcolor='#F9F9F9'><font color='#00A0C6'> İncelenme :</font> $cek[okunma] Kez İncelendi</td>
<td width='84' bgcolor='#F9F9F9'></td>
</tr>
<tr>
<td height='1' width='1241' bgcolor='#FFFFFF' colspan='3'>
<font style='font-size: 1pt'> </font></td>
</tr>
";
}
?>
</table>yardım ederseniz sevinirim
teşekkürler