Re: finder
| From: | Phpster | Date: | Thu, 16 Jul 2009 22:56:39 +0000 |
| Subject: | Re: finder | ||
| References: | 1 2 3 4 5 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-46325@lists.php.net to get a copy of this message | ||
On Jul 16, 2009, at 5:50 PM, "Emiliano Boragina" <emiliano.boragina@gmail.com
wrote:
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. +Select all columns ( fields ) from the building table Bastien Sent from my iPod_// 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.