Variable inside mysql_query

[alsaffar]

Hi there,

How I can use a varibale inside mysql_query?

I'm passing a varibale $TableName to a function, and inside the function I make my query depend on the passed variable.

$TableName = 'Users';
TestFunction($TableName);


Function TestFunction($TableName)
{
$Query = " SELECT ID FROM $TableName ";
$Result = mysql_query($Query) or die("Query Failed"
}

How I can get this function works fine?

 

[sleipnir214]

Your problem is not using the variable in an SQL query. Your problem is that your variable is not available inside your function.

You need to tell your function that the variable $TableName exists outside the function. The "global" keywork is used for this purpose.

Read

http://www.php.net/manual/en/language.variables.scope.php

for more information ______________________________________________________________________
TANSTAAFL!

 

[LTeeple]

Hi alsaffar! Have you tried:
$TableName = 'Users';
TestFunction($TableName);


Function TestFunction($TableName)
{
$Query = " SELECT ID FROM " . $TableName;
$Result = mysql_query($Query) or die("Query Failed"
}

The dot (.) is a concatenation operator, so when the query is processed it'll be read:
SELECT ID FROM Users

Hope this works for you!
Cheers
Laura