<?php
include "config.php";
$hold = "0";
$kk1 = "city";
$kk2 = "hold";
$kk3 = "how";
$kk4 = "hcat";
$kk5 = "hkind";
$kk6 = "price";
if ($how <> "اجاره"){
$main = "<div align='center'>
<table cellpadding='0' cellspacing='0' width='542' height='57'>
<!-- MSTableType='layout' -->
<tr>
<td width='542' height='19' colspan='6'></td>
</tr>
<tr>
<td width='542' height='19' valign='middle' colspan='6'>
<p align='right'><b><span class='sub'>نتایج جستجو</span></b></td>
</tr>
<tr>
<td width='91' height='19' bgcolor='#F8F8F8'>
<p align='center'><font face='Tahoma' style='font-size: 8pt'>
<span lang='fa'>اطلاعات </span></font></td>
<td width='53' height='19' align='center' bgcolor='#F8F8F8'>
<font face='Tahoma' style='font-size: 8pt'><span lang='fa'>تعداد اتاق</span></font></td>
<td width='83' height='19' align='center' bgcolor='#F8F8F8'>
<p dir='rtl'><font face='Tahoma' style='font-size: 8pt'><span lang='fa'>
متراژ کل(متر)</span></font></td>
<td width='100' height='19' align='center' bgcolor='#F8F8F8'>
<font face='Tahoma' style='font-size: 8pt'><span lang='fa'>قیمت</span></font></td>
<td width='119' height='19' align='center' bgcolor='#F8F8F8'>
<font face='Tahoma' style='font-size: 8pt'><span lang='fa'>نام منطقه</span></font></td>
<td width='96' height='19' align='center' bgcolor='#F8F8F8'>
<font face='Tahoma' style='font-size: 8pt'><span lang='fa'>دفعات بازدید</span></font></td>
</tr>";
$result = mysql_query("SELECT * FROM home WHERE $kk1 LIKE '$city' AND $kk2 LIKE '$hold' AND $kk3 LIKE '$how' AND $kk4 LIKE '$hcat' AND $kk5 LIKE '$hkind' AND $kk6 = '$price' order by id DESC");
while($r=mysql_fetch_array($result))
{
$price=$r["price"];
$hroom=$r["hroom"];
$hm=$r["hm"];
$hstatu=$r["hstatu"];
$count=$r["count"];
$id=$r["id"];
$main = "$main <tr>
<td width='91' height='19' valign='middle' align='center'>
<p dir='rtl'><font face='Tahoma' style='font-size: 8pt'><span lang='fa'><a href='home.view.php?id=$id'>
بیشتر...</a></span></font></td>
<td width='53' height='19' valign='middle' align='center'>
<font face='Tahoma' style='font-size: 8pt'>$hroom</font></td>
<td width='83' height='19' valign='middle' align='center'>
<p align='center'><font face='Tahoma' style='font-size: 8pt'>$hm</font></td>
<td width='100' height='19' valign='middle' align='center'>
<p align='center'><font face='Tahoma' style='font-size: 8pt'>$price</font></td>
<td width='119' height='19' valign='middle' align='center'>
<p align='center'><font face='Tahoma' style='font-size: 8pt'>$hstatu</font></td>
<td width='96' height='19' valign='middle' align='center'>
<p align='center'><font face='Tahoma' style='font-size: 8pt'>$count</font></td>
</tr>";
}
$main = "$main </table></div>";
}else{
$main = "<div align='center'>
<table cellpadding='0' cellspacing='0' width='542' height='57'>
<!-- MSTableType='layout' -->
<tr>
<td width='542' height='19' colspan='6'></td>
</tr>
<tr>
<td width='542' height='19' valign='middle' colspan='6'>
<p align='right'><b><span class='sub'>نتایج جستجو</span></b></td>
</tr>
<tr>
<td width='91' height='19' bgcolor='#F8F8F8'>
<p align='center'><font face='Tahoma' style='font-size: 8pt'>
<span lang='fa'>اطلاعات </span></font></td>
<td width='53' height='19' align='center' bgcolor='#F8F8F8'>
<font face='Tahoma' style='font-size: 8pt'><span lang='fa'>تعداد اتاق</span></font></td>
<td width='83' height='19' align='center' bgcolor='#F8F8F8'>
<p dir='rtl'><font face='Tahoma' style='font-size: 8pt'><span lang='fa'>
متراژ کل(متر)</span></font></td>
<td width='100' height='19' align='center' bgcolor='#F8F8F8'>
<font face='Tahoma' style='font-size: 8pt'><span lang='fa'>قیمت</span></font></td>
<td width='119' height='19' align='center' bgcolor='#F8F8F8'>
<font face='Tahoma' style='font-size: 8pt'><span lang='fa'>قیمت ودیعه</span></font></td>
<td width='96' height='19' align='center' bgcolor='#F8F8F8'>
<font face='Tahoma' style='font-size: 8pt'><span lang='fa'>نام منطقه</span></font></td>
</tr>";
$result = mysql_query("SELECT * FROM home WHERE $kk1 LIKE '$city' AND $kk2 LIKE '$hold' AND $kk3 LIKE '$how' AND $kk4 LIKE '$hcat' AND $kk5 LIKE '$hkind' AND $kk6 = '$price' order by id DESC");
while($r=mysql_fetch_array($result))
{
$price=$r["price"];
$hroom=$r["hroom"];
$hm=$r["hm"];
$hstatu=$r["hstatu"];
$count=$r["count"];
$vad=$r["vad"];
$id=$r["id"];
$main = "$main <tr>
<td width='91' height='19' valign='middle' align='center'>
<p dir='rtl'><font face='Tahoma' style='font-size: 8pt'><span lang='fa'><a href='home.view.php?id=$id'>
بیشتر...</a></span></font></td>
<td width='53' height='19' valign='middle' align='center'>
<font face='Tahoma' style='font-size: 8pt'>$hroom</font></td>
<td width='83' height='19' valign='middle' align='center'>
<p align='center'><font face='Tahoma' style='font-size: 8pt'>$hm</font></td>
<td width='100' height='19' valign='middle' align='center'>
<p align='center'><font face='Tahoma' style='font-size: 8pt'>$price</font></td>
<td width='119' height='19' valign='middle' align='center'>
<font face='Tahoma' style='font-size: 8pt'>$vad</font></td>
<td width='96' height='19' valign='middle' align='center'>
<p align='center'><font face='Tahoma' style='font-size: 8pt'>$hstatu</font></td>
</tr>";
}
$main = "$main </table></div>";
}
?>
