The * is a SQL shortcut. It means, in this case, all columns. So, in the SQL you posted it means get all columns from the buildings and city tables. corin dubdromic.com On Thu, Jul 16, 2009 at 06:50:20PM -0300, Emiliano Boragina 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. > > > > + _ > // 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 09:17 a.m. > Para: Emiliano Boragina > CC: php-db@xxxxxxxxxxxxx > Asunto: Re: 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. > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
