Hi Andrius! It is depending on the style of the table. There are some solutions. One way is to split the the table in definition and content. This is the most open solution. For example: Table: Definition ID Name ContentID Table: Content ID Language ContentValue ForeingKey: Definition.ContentID -> Content.ID Example Query: SELECT Content.Value AS value FROM Definition,Content WHERE Definition.ContentID=Content.ID AND Definition.Name='$Name' AND Content.Language='$Language' An easier way is to add a row "language" to the table. But this way is not so open for other dependencies of the content. The recreation of the table with different name is possible but is not so open too. bye Marcus "Andrius Jakutis" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hello, > > I am newbie, so, please give me advice. > > Ok, I have PHP webpage, where I give information from MYSQL database (Info > in english). I'd like to have website in german. Should I recreate (double) > tables (those, where is text which is needed to be translated), or there is > some clever solution? > > I have no idea. > > Thanks > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
