I am about the build a multi language website using PHP + MySQL.
It's for a real estate website and the translations will be manually interpreted (rather than automated like Google translate).
I am really looking for the most efficient way of creating this site.
I'm guessing i'll need a database table per language: one in english, one in spanish and one in french.
Would I then need 3 duplicate sites/directories? Is there a better way to do this?