2 DB's in one phpLD

[alva]

Now what I mean:

I want my directory to be in to two languages. German and English. I do not want person to make submit his link two times, that's why when he visits site and decides to submit his website he will see something like this:

1. website name
a. In english:
b. In German:
2. Website address:
will stay the same for both languages
3. other similar fields what is available in PHPLD
4. email
will stay the same for both languages

and when he clicks on SUBMIT in database information will be automatically saved in 2 different field. Next time when someone visits my Directory will choose to use German language site or English. If he clicks on german search will look in German data , if he clicks on English search will look in english data.

can someone help or maybe it's available already?
People who are mostly in other countries that are small will be interested to show their content for foreigners. Same way 2 templates will be also interested. . . :cool:

[anon]

you may want to look into triggers for mysql.

so basically, when the link gets processed in your main database and a field gets updated it sets off a trigger which then runs a process to add the same data into the other one.

I'm thinking two triggers. one for the links table and one for the categories table(just in case someone suggests a new category)