Re: Question about the scope of functions - I solved it

Hey all, Nevermind this. I just solved it myself. I found out it does not matter when you decalre a variable as global (other than I guess before you use it) So I made my function this way. function key_value ( $mysql ) {

        if ( $sao_row = $mysql -> fetchRow() )  {
                do {
                        global ${"$sao_row[0]"};
                        ${"$sao_row[0]"} = $sao_row[1]; // Create a variablle to pull the radio variable name
                }       while ( $sao_row = $mysql -> fetchRow() );
        }

} and it works like a charm. Phillip At 02:14 AM 8/31/2003 -0700, you wrote:

Greetings People, Now basically I am trying to set up an easy way to have key value pairs listed in a DB, and then be able to call the name of the key as a variable later in the code of the page and list the corresponding value in the DB. I am almost there. However I just need to figure out some scope issues with functions. I want to create variables with names on the fly through a function and have them last beyond the life of the function. However I do not want to have to declare each key/variable as a global variable in the function, will defeat the purpose of this. I have the following DB table

sao_key                         sao_value
app_past_enroll                         1
something                                       0
something_else                          1
yet                                             1

I have the following function function key_value ( $mysql ) {

        if ( $sao_row = $mysql -> fetchRow() )  {
                do {
                        ${"$sao_row[0]"} = $sao_row[1]; // Create a variablle to pull the radio variable name
                }       while ( $sao_row = $mysql -> fetchRow() );
        }

} I have the following code $sql = "SELECT sao_key, sao_value FROM staff_app_options

$sao = new MySQL ( $sql );      #       Create an object with the above query

key_value ( $sao ); echo 'Past Enrollment = ' . $app_past_enroll . NL; echo 'something = ' . $something . NL; echo 'something_else = ' . $something_else . NL; echo 'yet = ' . $yet . NL; So how do I get the script to read $app_past_enroll as a variable after it has been created by the function? Thanks for your help. Phillip -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Blessings Phillip +++++++++++++++++++++++++++++++++++++++++++++++++++ IMPORTANT: This email message (including attachments, if any) is intended for the use of the individual addressee(s) named above and may contain information that is confidential, privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social faux pas. Unless the word absquatulation has been used in its correct context somewhere other than in this warning, it does not have any legal or no grammatical use and may be ignored. No animals were harmed in the transmission of this email, although the barking dachshund next door is living on borrowed time, let me tell you. Those of you with an overwhelming fear of the unknown will be gratified to learn that there is no hidden message revealed by reading this warning backwards, so just ignore that Alert Notice from Microsoft. However, by pouring a complete circle of salt around yourself and your computer you can ensure that no harm befalls you, your family or your pets. If you have received this email in error, please add some nutmeg and egg whites, whisk and place in a warm oven for 40 minutes. +++++++++++++++++++++++++++++++++++++++++++++++++++