Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    1

    Multi language database design

    Hi!

    Ok, I'm designing a database to a website, where you first select your country and then your language.

    For example user chooses "Finland" as country and then selects language version "english" or "finnish" (there can be more options..).

    There will be a management system where administrator can easily add countries and languages. (and update the data of course).

    This is what I have now:

    tblCountry:
    id | countryname

    tblLang:
    id | langname

    tblData:
    id | countryid | langid | pageid | data

    (pageid is link1,link2,link3,link4... because the main menu is static)

    The main problem is the image gallery (kind of) with description text for every image and the gallery should also be multi country/language but I haven't figured out how to do it. I don't want to upload those pictures more than one time.

    tblPicturecollection:
    id | title | type

    tblPictures:
    id | collectionid | imgsrc | imgdescription

    And there's even more, but I'll stop here.

    Please help or give some advices if you have done this kind of systems before or you are others ways experienced.

    This is my largest project so far, so I'm little lost here.

    Thanks!

  2. #2
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    tblCollection(CollectionID, Title, Type)

    tblPicture(PictureID, CollectionID, Imgsrc)

    tblCaption(CountryID, LangID, PictureID, Caption)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •