storing variables from an sql query

[satsilem]

hello to everybody. I would like to ask your advice for something i try to build.

I want to make a multilingual, database driven website. So one of my thoughts is to stote in a MySQL table called "pages" all the elements of a page, like title, meta description, meta keywords and ect.

So at the beginning of my script I need to run a function that sould make a query to the table "pages" in order to find the elements of the page with the specific id and then store each value to an array or something in order to use it in the script globally.

I am newbiew on this, and i can imagine that its quite easy, but I have tried a few different ideas and nothing seems to work, I will appreciate some help.

thans in advance

[Kudose]

Most applications that are multilingual use a language file like this:

English.php

$hello = 'Hello';

French.php

$hello = 'Salut';

Then use them like so:

session_start();
$_SESSION['lang'] = 'English';
include($_SESSION['lang'].'.php');
echo $hello;

Hope that helps.

edit
The reason I used a file example over storing the information in a database is: Unless you are storing articles or some other sort of constantly updated or dynamic data, it would use far more resources to use the database to store the different languages.
/edit

[satsilem]

Thanks for the reply,

I will try this and I will tell you the results