RE: [PHP-DB] finder

[Emiliano Boragina]

But with that it doesnt difference between full and empty field…

If the user want search on two posibilities on ten...

+                                                                          _
   // Emiliano Boragina _
   // Diseño & Comunicación //////////////////
+                                                                          _
   // emiliano.borag...@gmail.com  /
   // 15 40 58 60 02 ///////////////////////////
+                                                                          _

  _____  

De: Dan Shirah [mailto:mrsqua...@gmail.com] 
Enviado el: Miércoles, 15 de Julio de 2009 08:54 a.m.
Para: Emiliano Boragina
CC: php-db@lists.php.net
Asunto: Re: [PHP-DB] finder

 

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'";

}