Dynamic variables from a MySQL Table?

[Anon]

In setting up a "delete record" page, i want to echo the record to the user first, to make sure they really want to delete it. I am currently doing it thus:
$foolish_array = mysql_fetch_array($record)$foo = foolish_array["foo"];
$bar = foolish_array["bar"];
etc....for each column.

I KNOW there is an easier way; where I can just define variables for each column name.
How can I do that?

Thanks for your help.

[angulion]

Jay wrote:

$foolish_array = mysql_fetch_array($record)$foo = foolish_array["foo"];
$bar = foolish_array["bar"];
etc....for each column.

How about:
$foolish_array = mysql_fetch_array($record);
extract($foolish_array, EXTR_OVERWRITE);

Check http://www.php.net/extract for more on extract.

[Anon]

It worked! Cool! This saves me a lot of time and hassle.

Thanks, Anders