I have a technical question regarding database management: Let's say I want to set up website in Asia for car sales (i.e. Asiacars.com - I don't own that domain, it is only an example) for several Asian countries. I will have a landing page that shows a map of Asia, and when the user clicks on his country (let's say Thailand) it will lead to a subdirectory of the site for his country where he can sell/buy cars. That subdirectory would be Aisiacars.com/TH and could be viewed under a Thai and an English language option. The site would have other subdirectories for different countries (i.e. Aisiacars.com/IN for India, Aisiacars.com/CN for China, and so on). Each subdirectory would be viewable underthat specific country's language and an English option. Each subdirectory would contain and be built on the same script, but would have information relating to the respective country (i.e. Provinces, City, Postal Codes, etc.). Now, can all these subdirectories use the same database, or would I need to set up a different database for each country? Has anyone had experience with something like this? Any comment is appreciated.
I would say the countries, Thailand or China for example, are just like categories where the country is also an identifier for that particular data or row in your table. You can have an in one table the ff: ID, User, Country, Buy/Sell, Car Make/Type, Car Brand, Mileage, Description, Buy/Sell Price, etc.. . You can then put in another table the details for each country such as: Country, Provinces, Cities, Postal Codes, etc.. .