[RESOLVED] variables from database

Dear PHP community,

I would appreciate it if you could help me out with this little problem.

Is there a way I can do this?

I have a table in my database that lists certain variables which are changeable on other pages.

The table looks like this
Var_id
Var_name
Var_par
Var_val

Ok so the id is irrelevant, the name is just a small description.

I would like the var_par to be retrieved as the variable name so on the page

I want it to work as whatever the value is,

$variable = $value;
$variable (the word variable is retreaved from var_par)
And
$value is retreaved from var_val.

I hope this all makes sense.

Well, you could do variable variables, something like:

while($result = mysql_fetch_assoc($query))
    ${$result['var_par']} = $result['Var_val'];

Alternatively, you could just use an array to keep things together:

while($result = mysql_fetch_assoc($query))
    $CONFIG[$result['Var_par']] = $result['Var_val'];

 while($result = mysql_fetch_assoc($query))
    ${$result['var_par']} = $result['Var_val'];

Worked fantastically,
Thank you.