[SOLVED] Fetch Array?

[AtomicRax]

Ok, here's what I have:

 

A MySQL table named "settings" with two fields- "name" and "value"

 

I have a query that looks like this:

$query = mysql_query("SELECT * FROM settings");
$settings = mysql_fetch_array($query, MYSQL_ASSOC);

 

(Currently there is only one result, but it will not stay this way.)

 

 

 

What I want to do:

 

Call any of the settings by their name... Like $settings[example] = "my value". How ever, with this current code, $settings[name] = "example" and $settings[value] = "my value"

 

Any help? Thanks.

[trq]

$settings = array();
if ($result = mysql_query("SELECT value FROM settings WHERE name = '$key'")) {
  if (mysql_num_rows($result)) {
    while ($row = mysql_fetch_assoc($result)) {
      $settings[$row['name']] = $row['value'];
    }
  }
}

echo $settings['example'];