zip code locator

[reiffel]

Let's see the brain childs work this one out! Ha!

I have a table that has a whole bunch of customers in there. One field that I am interested in is customer_zipcode. With that all of our customers have their zipcode listed.

Now, what if I want our managers to be able to put the store zip code in a box and then they define how many miles they want to travel such as 25 miles (hard code if you need to make it easier is fine).

Then what I would like to have returned is something similar to:
customer_id | customer_fname | customer_lname

How would I go about doing that? I figured that I would have to use a LEFT JOIN customers ON customers.zipcode = zip_code.zip_code .... but the rest I am kinda clueless on.

Anyone have any ideas on this?
Thanks!! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[lampard]

I think what you end up doing see is you get the manager drunk and push him out the door and replace him with someone younger and more eager to go wherever you damned well send him within a 1000 miles of your office. So don't worry about zipcodes just open the door and say "GO!" and see what happens. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --