Re: finder

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



>
> Hello… I must to do a finder with 10 posibilities.
>
> This 10 can be full or empty.
>
> (sorry... I just ask this but I’m not understand yet)
>
>
>
> I know how to do a finder about any field, but this is my first time with
> one like this where the user can find a “house” in a “zone” or find
> anything
> in that “zone”.
>
> I must use IF the field empty SELCET... if the field is full SELECT... that
> with all??
>
> Please... help...
>
> Thanks a lot


$house = $_POST['house'];
$zone = $_POST['zone'];
$abc = $_POST['abc'];

$query = "SELECT * FROM real_estate WHERE 1 = 1";
if ($house != "") {
   $query.="AND house = '$house'";
}
 if ($zone != "") {
   $query.="AND zone = '$zone'";
}
 if ($abc != "") {
   $query.="AND abc = '$abc'";
}

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux