James Doe Jr.
Reputation: 27
php INSERT INTO database variable name
When trying to use
$SomeTable = "SomeTable";
INSERT INTO "' . $SomeTable . '" SET ...
instead of
INSERT INTO SomeTable SET ...
I am unsuccessful. Why am I unable to use a php variable to call a database name?
Upvotes: 1
Views: 96
Answers (1)
RyanS
Reputation: 4194
You would need to use something like this:
$SomeTable = "SomeTable";
$query = 'INSERT INTO `' . $SomeTable . '` SET ... ';
Which uses the ` character instead of quotes
Upvotes: 2
Related Questions
- MYSQL: Insert variables into variable name table
- Inserting values into a table with a PHP-variable name
- How to Insert Data into Mysql using Dynamically created PHP Variable
- insert variable into database using php
- How to properly INSERT INTO MySQL Using PHP Variables
- Inserting variables into an database table using PHP
- Inserting data into table_name as php variable
- Inserting name into database?
- Inserting into database php variables
- Insert Variables into a table which is selected from a PHP variable name