显示数组的值

Question

I'm trying to get a specific value from a mysql_fletch_assoc array. I explain. Here is the database. Table: config with 2 fields: setting and value.

SETTING | VALUE
width | 100    
height | 50

And this is the query:

$result = (mysql_query("SELECT setting, value FROM config"));
while($setting = mysql_Fetch_assoc($result)){


    echo $setting['value'];
    echo "<br>";

Now i can see the entire array. I want to display every element individually. I tryed with $setting['value']['0'], $setting['value']['width'] with no success.

Edit: basically i want to do something like this:

echo $setting['value']['width'] gives -> 100 
echo $setting['value']['height'] gives -> 50

I hope that now it's more clear

Answer 1

First, may be there is a typo error mysql_Fetch_assoc, fix this to mysql_fetch_assoc.

And In order to receive the values on your pattern, do the following

$setting = array();
while($row = mysql_fetch_assoc($result)) {
     $setting['value'][$row['setting']] = $row['value'];
}

Now, you can implement them as you want

echo $setting['value']['width']; // will give -> 100 
echo $setting['value']['height']; // will give -> 50