Dynamic links
Well the DB I can help with as I know MySQL..
Can you access it directly thats the only thing in the way now?
If you can access the DB and can view the table names, don't post what they are called if you can, let me know and then I can write you some PHP code to query the DB and fetch the data, should work don't use Wordpress so not sure but hay we can give it a go.
You would also need to know the DB password and username again don't post them.
Separate language
How I would set it up is separate them into sub directories, preferably sub domains as sub domains are treated by the search engines as a separate site then just link to the sub folder with the other language in, then in there add a separate CSS sheet that way you get a separate language of your site indexed and thus hopefully in other language search results however that is not that easy or as simple as that, foreign language SEO is harder to pull off. Ideally you want each language to have it's own server placed in the languages main home country or where most of your visitors will come from in that language as well, as well as links with the right keywords in the other language pointing to the right language version of your site.
If however you just want to offer it to your site visitors set a link to the language then test for the variable and add a new CSS sheet, similar to how I do my zoom css sheet in the
accessibility thread.
So we have XHTML similar to:
<p>
Please chose your language below:
</p>
<ul>
<li><a href="this-page.htm">English</a></li>
<li><a href="this-page.htm?lang=francais">French</a></li>
<li><a href="this-page.htm?lang=deutsch">German</a></li>
<li><a href="this-page.htm?lang=italiano">Italian</a></li>
</ul>
Then at the top of the page ~
<link href="css/main.css" rel="stylesheet" type="text/css" media="screen" />
<link href="css/page2.css" rel="stylesheet" type="text/css" media="screen" />
<?php if(isset($_GET['lang']){
if($_GET['lang'] =="francais" || $_GET['lang'] =="deutsch"){?>
<link href="css/french-and-german-fix.css" rel="stylesheet" type="text/css" media="screen" />
<?php }elseif($_GET['lang']=="italiano"){?>
<link href="css/italian-fix.css" rel="stylesheet" type="text/css" media="screen" />
<?php }}?>
Then personally I would add this to the end of all your links.
<a href="some-page-url<?php if(isset($_GET['lang])){?>?lang=<?php echo $_GET['lang]; }?>">some page</a>
That way the get variable is added to the end of every link and if some one then clicks on the French version all the pages off it will then display the French version when they follow a link from that page as the get variable will be present if that makes sense.
If the user chooses via a form that bottom section will need to be changed and the top section will need to be changed to a post rather than a get let me know if that is how it is implemented or if you would like me to amend it for a form submission.
Jaz
Red ~ PHP
Blue ~ XHTML