RE: finder

["Emiliano Boragina" <emiliano.boragina@xxxxxxxxx>]

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.boragina@xxxxxxxxx  /
   // 15 40 58 60 02 ///////////////////////////
+                                                                          _

  _____  

De: Dan Shirah [mailto:mrsquash2@xxxxxxxxx] 
Enviado el: Miércoles, 15 de Julio de 2009 08:54 a.m.
Para: Emiliano Boragina
CC: php-db@xxxxxxxxxxxxx
Asunto: Re:  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'";

}