Assigning variable names from an array

[webpoet]

I would like to do the following but I´m not quite sure how:

1. I would have a db-table containing two columns: name and content
2. Select everything or just some rows from that database and
3. Create a variable for each row named after what´s in the name field on that row containing the string from the content field.

What I mean is if I have a db-table that looks like this:

Name Content
Variable1 text
Variable2 more text

I would end up with $Variable1 = "text" and $Variable2 = "more text".

Should be fairly simple but my brain just can´t seem to come up with a easy solution so help would be appreciated!

[rIkLuNd]

Try this:

// Get the content here in $result
$data = mysql_fetch_array( $result );

// Loop through the array
while( list( $name , $content ) = each( $data ) )
{
     ${"$name"} = "$content";
}