For creating a multi-language website, which is the best approach in
terms of performance, ease of use, maintainability:
a. add a languageID column to the primary key
b. add multiple description columns - one for each language
Eg:
Original table:
categoryID
description
Primary-key approach:
categoryID
languageID
description
Multiple description columns approach:
categoryID
description_en
description_es
description_ar
description_fr
description_de
description_jp
description_cn
...
any other better approach?
thanks
The php_mysql group is dedicated to learn more about the PHP/MySQL web database
possibilities through group learning.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/