"return" causing problems...

[nexgen_x]

Hi all, can anyone explain to me why this function:

function sql_lang($lang) {
	//this function gets the value of lang, allowing SQL Queries to access the right tables
	if ($lang == "eng") {
		//access the english review table
		$rev = "reviewsGB";
		return $rev;
	} elseif ($lang == "ger") {
		//access the german review table
		$rev = "reviewsD";
		return $rev;
	} else {
		//redirect user to language select page, because they have accessed this page without specifying a language
		header("Location: [url]http://www.metal-observer.com/[/url]");
		exit;
	}
}

in the file "default.php", refuses to return $rev to part of another script:

include ("../default.php");
sql_lang($lang);
$query = "SELECT * FROM $rev";
...etc

? I can't understand it...
I've tried doing a

print $rev;

But that didn't print anything, so I know its a problem with the return. Also, if I access the page when lang does not equal "ger" or "eng" the header does indeed redirect me, so its not a problem with the $lang variable...

can anyone help please?

Cheers,

[diego25]

It should be

$rev = include("file");

Remember, when you include a file, you're creating another variable scope. So the variables created in the included file won't be available in the "includer" file unless you assign it to something.

Diego

[nexgen_x]

Thanks

One thing though, the function sql_lang() is one of several functions in the file I'm including, default.php... So for the "includer" page, do I need to do this:

$rev = include ("../default.php");
sql_lang($lang);

Or something else?

Cheers,

[nexgen_x]

Got it,

include("../default.php");
$rev = sql_lang($lang);

Not sure why I didn't figure that out, I knew that the returned value had to be stored in a variable... ahh well, all sorted now 😉