Dealer Locator

[Anon]

I have been searching for a few days for a dealer locator script that I can freely use. The user should be able to enter their zip code and a radius to search (10 ,20, 30 miles). I am using PHP and MySQL (newbie). I have downloaded the 2000 census zip code data and used it to create my zip code table. I have also created a table for my dealers. I have seen a lot of references to this script

http://px.sklar.com/code-pretty.html?code_id=253

I can't seem to get it to work. The zipdy script does not work with MySQL.

I have seen some information that says you can have the customer enter the zip code and radius and use the zip code to find the customer latitude and longitude, then calculate distances to all the dealer locations to find the correct radius and list the specific dealers. I did find a few php calculations for distance using latitude and longitude.

How would I get this to work??

[Anon]

Just out of curiosity...... at the top of that code, where it says, "localhost:3306"....

did you change it to just say, "localhost"

so it looks like:
$conn = mysql_connect("localhost","uid","pass");

[Anon]

I did change the code to connect. I can get to the database and run simple queries, like select * from dealer where zip='35634' and print the results to the screen.