mysql QUERY error

[jjdave]

 

Hi All,

I have a variable which contains name of a Database Table:

How can I pass this variable into the Query to access a data from the table, following are my code. I want to know whats wrong. I hope I am clear enough. I am using mySQL with PHP.

 

$table_name = $_GET['table_name'];

 

$query="SELECT * FROM `$table_name` ORDER BY id";

$result=mysql_query($query);

$num=mysql_numrows($result);

 

Thanks.

[Mattyspatty]

$query="SELECT * FROM `".$table_name."` ORDER BY id ASC|DESC";

[AV1611]

Are backticks valid for tablename? I thought they were for fieldnames...

 

$table_name = $_GET['table_name'];
$query="SELECT * FROM '$table_name' ORDER BY id"; 
$result=mysql_query($query);
$num=mysql_numrows($result);

 

Hi All,

I have a variable which contains name of a Database Table:

How can I pass this variable into the Query to access a data from the table, following are my code. I want to know whats wrong. I hope I am clear enough. I am using mySQL with PHP.

 

$table_name = $_GET['table_name'];

 

$query="SELECT * FROM `$table_name` ORDER BY id";

$result=mysql_query($query);

$num=mysql_numrows($result);

 

Thanks.

298218[/snapback]

 

[Cook]

Backticks are fine for all identifiers within MySQL queries, to protect from using an identifier that would also be a keyword.

 

Your query should be just fine like so, ie the way you put it at first. Is there anything wrong with it? Do you get an error?

 

[!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--]

$table_name = $_GET[\'table_name\'];

 

$query = \"SELECT * FROM `$table_name` ORDER BY `id`\";

[/span][!--PHP-Foot--][/div][!--PHP-EFoot--]