View Full Version : MySQL Programmer

11-16-2011, 06:40 PM
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.

11-16-2011, 07:21 PM
Hello 7masscom!

Is this a sort of paid project? Let me know your thoughts. Would it be possible for you to send in the detailed specs of the project at my email: nicole@wickedinnovations.com so we can evaluate on it and will get back to you with the quotation.

Let me know your thoughts then.

Kind Regards,

11-16-2011, 08:26 PM
Do you have a dataset of all the ZIP codes (postal codes) and their geo data (lat / long) for each one? I know the US Census keeps a file of US Zip codes and their Geographic centers, but I'm pretty sure the UK and other nations charge for that data. Or are you only concerned about US data at this point?

Second, do you have Geo data for each of your addresses? You'll need that to determine the closest 3, otherwise, you could work with Google API to get the geo data depending on how many businesses you have.

I've done this type of work in the past and can help you out. If you're interested in a quote, just send me a PM.

11-17-2011, 09:59 AM

We are interested work with you. Will you please give me your contact details?