Creating variables from named fields

[Anon]

I'm not sure how to go about this, but I wanted to mysql_query and return each field as a variable containing it's value. For instance...

I have 3 fields.
id
name
email

Example:
$result mysql_query("select * from users where id='3'", $database);

I want to use $id $name and $email instead of having to do something like..
$id = mysql_result($result, 0, "id");
etc..

[[deleted]]

Use mysql_fetch_array() to get an associative array of the key/value pairs of the row.
Loop through the array and use list() to get the key/value pairs. (the name of the field and it's value.
Use variable-variables to define the new variables:

$column_name="test";
$$column_name="value";
echo $test;

output: "value"