Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New to the CF scene
    Join Date
    Nov 2011
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MySQL Programmer

    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.

  • #2
    Regular Coder nicole_anderson's Avatar
    Join Date
    Aug 2011
    Location
    OVER the TONE
    Posts
    143
    Thanks
    8
    Thanked 2 Times in 2 Posts
    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,
    Nicole

  • #3
    Mega-ultimate member
    Join Date
    Jun 2002
    Location
    Winona, MN - The land of 10,000 lakes
    Posts
    1,855
    Thanks
    1
    Thanked 45 Times in 42 Posts
    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.

  • #4
    New to the CF scene
    Join Date
    Sep 2011
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi,

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


  •  

    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •