A custom function question.

[crowden]

Hi,

I'm trying to write a function that grabs certain fields from a database query.

function QueryVars($start, $end)
{
    $question = array();
    for($i=$start ; $i <= $end; $i++)
    {
    $question[$i] = $row["quest_".$i];
    }
    return $question;
}

$sql = "QUERY";//QUERY is a sub for my actual SQL
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);

$question = QueryVars(1, 21);
var_dump($question); 

When I dump out that array I get all NULL values.

array(21) { [1]=> NULL [2]=> NULL [3]=> NULL [4]=> NULL [5]=> NULL [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL [10]=> NULL [11]=> NULL [12]=> NULL [13]=> NULL [14]=> NULL [15]=> NULL [16]=> NULL [17]=> NULL [18]=> NULL [19]=> NULL [20]=> NULL [21]=> NULL }

Can I get some help on what I'm doing wrong?
Thanks!

[kromey]

Because $row is undefined within the QueryVars function. You need another parameter to the function and pass in your $row variable.

[-T-]

A function is it's own little world, nothing from outside can be seen or changed from within. Only way to see it is to send it in as a parameter or set the variable as global (setting as parameter is prefered though)

function QueryVars($start, $end, $row) 
{ 
    $question = array(); 
    for($i=$start ; $i <= $end; $i++) 
    { 
    $question[$i] = $row["quest_".$i]; 
    } 
    return $question; 
} 

$sql = "QUERY";//QUERY is a sub for my actual SQL 
$result = mysql_query($sql); 
$row = mysql_fetch_assoc($result); 

$question = QueryVars(1, 21, $row); 
var_dump($question); 

[crowden]

thanks to both of you.