i am using jquery ui autocomplete to populate the street, city and country. So i'm looking ways to program in php if the param term pass to server by looking up the street name only but not the city and country
example:
search term: taman melati
search result:
Taman Melati Utama, Kuala Lumpur
Taman Melati Utama is the street name and Kuala Lumpur is the city name. As you can see, it only match the street name where the mysql only match it in the column street but if the search term like this
Taman, Kuala Lumpur
I want to match the search term into two fields where the "Taman" will be look up in the street field and "Kuala Lumpur" in the city name
How's that possible in PHP
You can use keywords in jquery ui autocomplete.