[Alex.css]

Hi everybody !
I code a little bit in PHP but I'm still unable to do something with the MySQL database.

And this time, the PHP code I would ask is news system, not ordinary.

I have a website and it will be translated in french soon. What I need is news system like:

[French Title] (the text field)
[French News] (textarea field where the news will be written)

HR

[English Title] (the text field)
[English News] (textarea field where the newser will translate the news)

...

After, the data selection with the $_GET method.

Example the url: mysite.com/index.php?lang=EN

will take only english news

and the url: mysite.com/index.php?lang=FR

will give only the french news.

so... in script, it gives something like this without PHP:

HTML Code:

<!-- news_new.php -->
<form action="news_send.php"method="POST">
<label for="title_en">News's Title</label>
<input type="text"maxlength="255"id="title_en"name="title_en" />
<label for="news_content_en">News Content :</label><br />
<textarea cols="15"rows="25"name="news_content_en"id="news_content_en">Enter your news here</textarea>

<hr>

<label for="title_fr">Titre News</label> <!-- Don't worry, it's translated in french ^^ --><input type="text"maxlength="255"id="title_fr"name="title_fr" />
<br />
<label for="news_content_fr">Contenu de la news :</label><br />
<textarea cols="15"rows="25"name="news_content_fr"id="news_content_fr"></textarea>


<input type="submit"value="Send" /><input type="reset"value="Reset" />
</form>

And finally, the PHP code wich will send the "news":

PHP Code:

<?php

if($_GET['lang'] == "EN")

{

  // This is the english news

}

elseif($_GET['lang'] == "FR")

{

// This is the french news

}

else

{

?>

<script type="text/javascript">

document.location.href=select_lang.php

</script>

<?php

}

// end of the main page example

?>

Fiou. If you understood what I meaned , please could you help me if you are able, of course^^ .

Thanks in advance.

Alex.css

[staticfire]

I am slightly confused.. are you wanting a system which translates english to french?

[Alex.css]

No no.
It would be too hard and impossible.

The newser who will make the news will translate manually the news in the other field.
Ex:
English Content field: The newser enter the news, in english

French Content Field: the newser translate the news in french by himself.

If he don't translate, it's not very important, the news won't be shown in this language.

Sorry if it's hard to understand, I'm very bad to explain ^^