google maps api help with search!

[andrewliu]

Hello. I'm new to php and I'm just getting my foot wet. But I've been going through lots of tutorial and I was looking into this google tutorial: http://code.google.com/apis/maps/articles/phpsqlsearch.html#findnearsql and its what I wanted it to do. Calculate a nearby store locator.

But I was curious about how to modify it by instead of outputting the data like it in the tutorial, but outputting against some kind of search term like in yelp.com where if you search a restaurant and have location, it will output nearby restaurants from their database

Thank you

[pritaeas]

If your search terms are in the same table, you can just add a WHERE clause to the query, before the HAVING.