I'm using wpdatatables to serve 2 purposes.  I have one table where logged in users can edit the front end (where only they can see it) and input their information.  This information includes an address.

I then have an additional view where I created another table using MySQL that doesn't allow front end edits, but simply queries the table above to display all the listings.  This is where I need help.  Is it possible to edit the search on this view to allow for a radial search on the zip code?

the website is www.youngsdrumcompany.com

The "Manage Local Listings" (menu on left) is where logged in users go to add/edit their info.

The "View Local Listings" is where anyone can go to view all the listings added.  This is where I need the radial search capability.  Is this possible?  Thanks, David

I would like to search the table by zip code.  Meaning, any listing within X miles of the searched zip code.  Right now the search box just searches all the fields (without a search button).  Is there a way to modify the search to allow for a box/drop down to select the number of miles and a search box for the zip code.  The distance would be calculated against the zip code field in the table data.  When the search is preformed, only the listings within the designated number of miles would be displayed.  Thanks, David

If this is something that can't be done, how much would you charge to add it in?  Thanks!

Hello?