We have several material suppliers that we work with. We have small access database which can be exported into CSV format as follows,
category1, category1_subcategory, address, city, state, zipcode
So we want to have a small script which can generate static HTML files in following format,
1) Pages sorted by Categories, Sub Categories, state, city, Suppliers listings (multiple pages)
2) Pages sorted by State, City, Categories, Sub Categories, Suppliers listings (multiple pages)
3) Save ( Categories + Sub Category + Zip Code + Generated Page Number) in MySQL Database.