Is this possible? Search Reviews by ZipCode?

[InterFX]

I am working on a new client proposal, and one of the items they would like on their site, is a way to quickly seacrh reviews based upon a zip code?

I know zip code integration is possible with ReviewPost, but wanted to know if anyone has done this yet?

Ideally, a user would come to the site, type in their zip code, and find all of the products (restaurants) listed in order closest to their zip code?

Anyone try this yet?

Thanks in advance -
InterFX

[Chuck S]

Nope adding a sort on zipcode is easy in the sort table but there is no code to display by distance sort.

INSERT INTO rp_sort VALUES (7,'ZipCode', 'ORDER BY disporder,zipcode');