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/
 



Reply via email to