RE: [PHP-DB] finder
| From: | Emiliano Boragina | Date: | Wed, 15 Jul 2009 12:10:45 +0000 |
| Subject: | RE: [PHP-DB] finder | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-46306@lists.php.net to get a copy of this message | ||
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@gmail.com /
// 15 40 58 60 02 ///////////////////////////
+ _
_____
De: Dan Shirah [mailto:mrsquash2@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 Im 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'";
}