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
case you have to put like on two field and if data is quite large then
implement full text searching.
It is very easy to implement . Please follow the instruction written below
Full-text Search is a feature introduced to MySQL in version 3.23.23.
This is how I used it to fix my problem:
I started out with an update to my table:
ALTER TABLE property ADD FULLTEXT(Address, City);
This set ups our Full-text index. The (Address, City) part tells us
problem.
<?php
?>
On Mon, Jun 29, 2009 at 8:23 PM, Emiliano Boragina
<emiliano.boragina@gmail.com> 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
>
> --
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
The Gate of Change is Locked on the INSIDE.
|