I´m building a database for my website, and I have around 30 languages to translate it to.
I build a table for languages, and I want to relate content to it.

Example:

table languages
language
language_short (content example : EN)

table navigation
language_short (related, EN or CRO for croatian, depending on the row)
logout (example : logout, "odlogiraj se" in croatian)
signup
jointhefans
firstname
surname
email
country (rel)
city (rel)
select gender
month
day
year
pleasetype
doyouagree
So you see the problem?
How do I structure so many information without having to make so many collumns? How do I make it more simple, while I still structure the content into a logical database?

When I develop multi lingual applications I look at this in a different way. I use a concept of labels. So you start off with a label called FIELD. In english we would translate that into Field, in Spanish Campo, in French champs ... So my table structure is

LabelName, LanguageID, LabelValue

THX!! How could I have not seen that? xD