RE: [PHP-DB] finder (I AM REALLY SORRY)

2009-07-17 Thread Emiliano Boragina
/ // 15 40 58 60 02 /// + _ -Mensaje original- De: Yves Sucaet [mailto:yves.suc...@usa.net] Enviado el: Viernes, 17 de Julio de 2009 10:08 a.m. Para: php-db@lists.php.net Asunto: Re: [PHP-DB] finder (I AM REALLY SORRY) Hi List,

Re: [PHP-DB] finder (I AM REALLY SORRY)

2009-07-17 Thread Yves Sucaet
each other out, but this has just been a stepwise build-up of how to write his real-estate application. Just my two cents, - Original Message - From: "Emiliano Boragina" To: Sent: Friday, July 17, 2009 12:16 AM Subject: [PHP-DB] finder (I AM REALLY SORRY) Sorry a lot of ti

Re: [PHP-DB] finder (I AM REALLY SORRY)

2009-07-16 Thread Jack van Zanen
not quite if $f_inmueble > 0 is false (<=0) than this will not be part of the search and the next line will add a AND following the WHERE which is syntax error so try this: $sql_BUSQUEDA = "SELECT * FROM principal FULL JOIN detalles WHERE 1=1 '"; //1=1 is always true if ($f_inm

[PHP-DB] finder (I AM REALLY SORRY)

2009-07-16 Thread Emiliano Boragina
Sorry a lot of times!!! Please... tell me (and help me) to know if this is right: = $row['precio'] <= $f_hasta; if($f_codigo == "") { $sql_BUSQUEDA = "SELECT * FROM principal FULL JOIN detalles WHERE '"; if ($f_inmueble > 0) { $sql_BUSQUEDA .= " inmue

Re: [PHP-DB] finder

2009-07-16 Thread Jack van Zanen
> > + > _ > > > > _____ > > > > De: Dan Shirah [mailto:mrsqua...@gmail.com] > > Enviado el: Miércoles, 15 de Julio de 2009 09:17 a.m. > > Para: Emiliano Boragina > > CC: php-db@lists.php.net > > Asunto: Re: [PHP-DB]

[PHP-DB] finder

2009-07-16 Thread Emiliano Boragina
Hello… hello… and hello everyone… I am sorry again to disturb this. I’ve got this from a web: $sql = "SELECT buildings.*, city.* FROM buildings, city WHERE buildings.idcity = city.id "; if (isset($_POST['txtSearch'])) { $sql .= " AND buildings.title LIKE '%" . $_POST['txtSearch'] . "%'

Re: [PHP-DB] finder

2009-07-16 Thread Phpster
.com / // 15 40 58 60 02 /// + _ _ De: Dan Shirah [mailto:mrsqua...@gmail.com] Enviado el: Miércoles, 15 de Julio de 2009 09:17 a.m. Para: Emiliano Boragina CC: php-db@lists.php.net Asunto: Re: [PHP-DB]

Re: [PHP-DB] finder

2009-07-16 Thread Corin Schedler
_ >// 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 09:17 a.m. > Para: Emiliano Boragina > CC: php-db@lists.php.net > Asunto: Re: [PHP-

RE: [PHP-DB] finder

2009-07-16 Thread Emiliano Boragina
15 40 58 60 02 /// + _ _ De: Dan Shirah [mailto:mrsqua...@gmail.com] Enviado el: Miércoles, 15 de Julio de 2009 09:17 a.m. Para: Emiliano Boragina CC: php-db@lists.php.net Asunto: Re: [PHP-DB] finder But with that it doesnt difference between full and empty field… If the us

Re: [PHP-DB] finder

2009-07-15 Thread Dan Shirah
> > But with that it doesnt difference between full and empty field… > > If the user want search on two posibilities on ten... > Maybe I'm not understanding what you're asking... Or maybe you don't understand the query... Say your form has 10 checkboxes. If the users picks 3 out of ten boxes a

RE: [PHP-DB] finder

2009-07-15 Thread Emiliano Boragina
5 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 thi

Re: [PHP-DB] finder

2009-07-15 Thread Dan Shirah
> > 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

[PHP-DB] finder

2009-07-15 Thread Emiliano Boragina
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