I'm currently working on a new website for a discount network of professionals. The client is asking for a couple additions that I can't figure out. I need someone with a good of understanding of MySQL for the following:
First, they want a Zip Code Proximity search that will return the three closest professionals in the network after the potential customer inputs their zip code on the site. This is different then most because they don't want a set radius,so no matter where you are in the world, it will give you the three closest professionals to you. It probably needs the use of the Haversine formula (or something similar). I've found some code that does the calculation and have a zip code database, but I can't get it to work.
Second, once the three closest professionals are revealed, they see discounted prices for each. If the customer likes the price, they select it and lock in the price by placing a down payment. This is straight forward (and I can do this myself). Next, the client wants the customer brought to a detailed page of the three professionals (after the payment) so the three results need to be brought back after the secured payment.