[PHP-DB] multiple finder

2009-06-29 Thread Emiliano Boragina
Hi, I must do e finder for properties... I know do a simple search but not a search like this with more one possibility, with all or some fields full... How do it? Thanks a lot -- +                                                    _   Emiliano Boragina //   Diseño y Comunicación / +

Re: [PHP-DB] multiple finder

2009-06-29 Thread Jason Gerfen
Emiliano Boragina wrote: Hi, I must do e finder for properties... I know do a simple search but not a search like this with more one possibility, with all or some fields full... How do it? Thanks a lot Example database table to search: TableName Field001 Field002 Field003 Example SQL to se

Re: [PHP-DB] multiple finder

2009-06-29 Thread Ankur Singh
Hi, You can do this by full text searching. Full text seaching will be 10 times faster than. Suppose your property name is " Power Bridge " and City name is "London" in this case any one can fill complete address like "Power bridge london" or some one can fill like above situation. So in this case