tmiller85

Thanks for the quick reply. Yes, creating a table with every county/state is my first step. I'm just not sure how to accomplish that. Is there a way for me to create a table with the data already within my links? I imagine/hope it would look something like this: State County Product1 Product2 Product3 PA Bucks $100 $110 $115 PA Chester $125 $135 $155 PA Delaware $150 $165 $175 PA Phila $150 $175 $200 So my goal is to have a format similar to the above which allows me to enter pricing for the entire country. Then, I'll work on transferring this data. Thanks again for your help.

Hello. I'm new at this so hopefully I can properly explain what I'm trying to accomplish. I'm using Dreamweaver MX 2004. I'm working on a national map for my employer that shows pricing for every county in the US (http://www.uresinc.com/dev/coverage/index.php). Right now, I have every link being sent to a page called rates.php. And on that page, it shows the County and State for the specified link. But the product pricing on the page is currently the same for every link. I'm trying to accomplish two things.... First, I want to see if there's a way to create a script or something that results in an Excel spreadsheet of columns that shows every county of every state. Then, I want to add columns for each product and input the correct pricing. There are 3,034 counties, so my spreadsheet would have that many rows. Right now, I have a tool called phpMyAdmin-2.5.6 but it requires me to manually enter the state, county, product, then price. Using this method, I would have to do that over 15,000 times if we list 5 products. Second, if my first request is possible, I need to transfer that data into my database so that the rates.php page pulls the right pricing for the specified county. I'm not sure how that would take place, if it's even possible, so I would need some direction on that as well. Thanks in advance for any feedback and sorry if my message seems confusing. Ted Miller