How to put this data in one database?

All,

I’m trying to add a feature to my site to show basic allowance for housing (BAH) rate based on zip code. Basically, you enter a zip code, select married or single, and are then shown how much money you will get per month for that area.

All of this data is available for download here in comma delimited format: http://www.defensetravel.dod.mil/pdc-archive/bah/ascii/2010/

I know how to import the data into a MYSQL database, however, the data is very split up.

For instance, one file contains regions which map to multiple zip codes for each region. Another file contains regions on the left column, with rates listed our for each area by rank. But the rates for married and single are separated into two different files.

Should I upload the files into multiple tables, then try to join them with queries? Or should I link the tables somehow? I’m not sure how to go about this. Please let me know if you have any advice!

Thanks,
Casey

put the results into one table

this will require massaging the data if the source files are in different formats

All,

Thanks for the tips. I figured it out using three separate tables, switching the query based on single or married.

Thanks,
Casey

Yep, drop everything into a landing table. Once you do that use an application language to run queries that place the data in the table(s) that it actually needs to go.