Re: finder

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 







On Jul 16, 2009, at 5:50 PM, "Emiliano Boragina" <emiliano.boragina@xxxxxxxxx > 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.



Select all columns ( fields ) from the building table

Bastien

Sent from my iPod
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux