RE: [PHP-DB] finder
| From: | Emiliano Boragina | Date: | Thu, 16 Jul 2009 21:50:20 +0000 |
| Subject: | RE: [PHP-DB] finder | ||
| References: | 1 2 3 4 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-46323@lists.php.net to get a copy of this message | ||
Hi again
I searching in www and find this (to do the finder):
$sql = "SELECT buildings.*, citiy.* FROM buildings, city WHERE
buildings.idcity = city.id ";
Dont understand building.*... what do it means?
Thanks.
+ _
// 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 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 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 and clicks submit, the example I gave
you will search your database looking for all records that match the 3 check
boxes.
if $houses equals $_POST['houses'] then $houses will be empty if the
checkbox was not clicked and will not be included in the query.