and also represents poor/lazy programming (in my opinion) leaving you open to all sorts of trouble if columns get added or deleted. I always advise to querry exactly what you require. Sorry for this comment but op seems to be fairly novice on SQL and could benefit from this post. Brgds Jack 2009/7/17 Corin Schedler <corin.gs@xxxxxxxxx> > 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 > > -- Jack van Zanen ------------------------- This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation
