Thank you, Thank you
Now I get to start on an Administration control panel
Believe it or not the hardest thing Ive had to create was this:
You pass the stored procedure a zip code, it first checks the site table to see if we have a site for that zip code, if it doesn't then I had to calculate mileage (in miles) between all zip codes in that block (99,50, etc), then return the city id for the closest city we have a site for. If the zip code has a site associated with it then I pass back the city's id. To accomplish this I needed a table populated with all 39,000+ zip codes in the US.
Calculating the mileage between zip codes was fun, really got to use some of the math I took in college (and they tell you that you'll never need that stuff after you graduate lol)
I think I'm gonna write a tutorial on creating a "Store Locater" for a site
This post has been edited by PsychoCoder: 25 Apr, 2008 - 10:33 PM
25 Apr, 2008 - 07:56 PM
| 