Turning data from MySQL to an array

[rIkLuNd]

I have a table with some config for the discussion board that I'm creating, but I just can't seem to get the data from the table. I've tried everything(that I know of...) but I haven't had any success...

CREATE TABLE cfg(
name VARCHAR(50) NOT NULL,
value VARCHAR(50) NOT NULL
);

What I want to do is to get the data from the 'cfg' table, and put them into an array, so that I can use them in my pages... Please help me!

This is how far I've come:

<?php

# Connection Stuff Here - Working Fine

$sql = "SELECT * FROM cfg";

$result = mysql_query($sql);
if(!$result)
die(mysql_error());

# This is where I just don't seem to be able to turn the values
# in the 'cfg' table into an array that I can use... I'm probably
# missing something really simple... Or not...
# Should I use mysql_fetch_array here, or what?!

?>

[SpasePeepole]

while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
foreach ($row as $name=>$column)
  {
  echo "$name : $column";
  }
}

That should work