Hello,
I have been given the task to write the following program:
This company has a bunch of salesman that are each given areas of the country to sell to, based on zip codes. So that salesman 1 would get 10000 – 30000 range of zip codes or something like that. The owner wants a form that asks for the customers zip code and then based on that, sends the form info to the appropriate salesman in their area.
I was wondering if there is a way to get the zipcode and see if it falls in a certain range and if its possible to do that in MySQL. I hate to have to write every zip code into the database, there are way too many, not to mention the size that the table would get too.
Let me know your thoughts…