Need some hints for a multi-language (mysql) site

I have been looking around at Google without too much success because I need some tips for a website I am making now. It is for a travel agency and the core of the website are, of course, the accomodations that can be rent. A table could have fields like an accomodation_id, the accommodation name(= page title), maximum number of persons, a picture_id that refers to another table with pictures but I am a little bit puzzled about the descriptions that come in several languages. I think it is NOT a good id to make fields like description_french, description_german, description_english etc, I guess there should be something like a table of descriptions that contains fields like the description itself, a language_id and an accomodation_id. However there are not only accomodations, the more general info pages will be also translated in all the available languages, they "behave" much the same like the accomodation pages as for the title and the pictures that are shown. Anyway some tips would be welcome, I am aware that there must be some info about it "somewhere" on the web but as I said probably I didn't "google" for the right keywords. FYI, the site is made with php and mysql but obviously my question refers to the "thinking" I have to do before starting to write the code.
Thanks for any help

Martien. Received on Sat Mar 18 2006 - 19:54:54 CET