Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2005

    Database builder + query

    Is there a simple system for an end user to install on a website so a business can enter in a list of their members and then be able to give out access so other members can search and connect with other people from the same zip code?

  2. #2
    Join Date
    Apr 2009
    I am not sure what exactly you are looking for. But chanced are rare for such a script.
    But you can easily code this using php. Just have to insert the users with their zip and other details and while searching just do a mysql query using the LIKE command or a WHERE "=" clause.

  3. #3
    Join Date
    Aug 2007
    Brighton, UK
    Such systems do exist - a good place to start looking is probably (or pick another scripting language of your choice) - you can't easily code them in PHP if you don't know PHP!
    The issue with finding users that are "near" each other is that you have to map zip codes to latitudes and longitudes - this is called geocoding. Once you have latitudes and longitudes you can use something a bit like Pythagoras theorem to find those that are close to each other. Google maps has an API that will allow you to do the geocoding and there's probably scripts on that will do this for you.

Similar Threads

  1. updating an online database query
    By Davey Gale in forum Programming Discussion
    Replies: 12
    Last Post: 02-02-2005, 09:30 PM
  2. How To Install A Database With One Query?
    By Barti1987 in forum Programming Discussion
    Replies: 15
    Last Post: 05-18-2004, 10:43 PM
  3. PHP: How to query a MySQL Database?
    By mercury in forum Programming Discussion
    Replies: 5
    Last Post: 11-21-2003, 05:53 AM
  4. Web page redirect after database query
    By Casexx in forum Hosting Security and Technology
    Replies: 1
    Last Post: 01-20-2003, 04:54 PM
  5. Query For Database size
    By AudiBoy in forum Hosting Security and Technology
    Replies: 3
    Last Post: 04-15-2002, 03:11 PM

Posting Permissions

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