Variables in an array

I'm trying to put a mysql query into a function, however when I do a mysql_fetch_array I need to specify the row's name. How can I put a variable in a function?

function config($setting_name,){
   开发者_如何学JAVA while($config_db = mysql_fetch_array(mysql_query("SELECT {$setting_name} FROM config WHERE id='1'") {
        echo $config_db['@@@@HERE@@@@'];
    }
}

while($config_db = mysql_fetch_array(mysql_query("SELECT $setting_name FROM config WHERE id='1'") {
    echo $config_db[$setting_name];
}

Be sure not to pass user input directly into this function. Also, I don't think you need the curly braces, because it's not a complex expression.

You can use the mysql AS keyword and get an alias for it. Like this:

    // Using MyOutput in query:
    function config($setting_name,){
        while($config_db = mysql_fetch_array(mysql_query("SELECT {$setting_name} AS Myoutput FROM config WHERE id='1'") {
            echo $config_db['Myoutput'];
        }
    }