why doesn't this work?

[delphi123]

I've got a php page which is including a config page at the top like this:

 

include("includes/rating_config.php");

 

now in this config file I've put a variable declaring the table name ($table="table1"

 

Now when I refer to it in the file within a function in the SQL query, it doesn't work, however when I put it inside the function like this:

function getRating($id){
$table = "table1";
$sel = mysql_query("SELECT rating_num FROM $table WHERE rating_id = '$id'");
}

It works perfectly!?

 

Is there a way of making my variable work within functions?

 

 

?>

[themistral]

You could try adding the tablename to the function parameters

 

function getRating($id, $tablename){
$sel = mysql_query("SELECT rating_num FROM $tablename WHERE rating_id = '$id'");
}

 

 

Then when you call the function, use the variable from your include file.

[p2grace]

You could also try adding "`" around the mysql fields.

 

function getRating($id, $tablename){

$sel = mysql_query("SELECT `rating_num` FROM `$tablename` WHERE `rating_id` = '$id'");

}

[revraz]

If you don't pass a variable to the function, it can't see it.  Search for Variable Scope

[spadmore]

This is a typical variable scope problem.

That variable is not on the stack of that function by default and must be passed in by reference or by value.

 

- Shelon Padmore