I have tried putting quotes around the variable so that it is "$TB_Name" I tried .$TB_Name. did not work
If I substitute the Variable with a name such as DORLIST
the table gets created correctly
Code: Select all
<?php
<?php
// I echo the Variable name out to make sure it is correct
echo "$TB_Name <br />";
include $_SERVER['DOCUMENT_ROOT']."/php/connectdor.php";
$sql = 'CREATE TABLE $TB_Name (
id int(6) NOT NULL auto_increment,
Title varchar(5) NOT NULL,
Last_Name varchar(25) NOT NULL,
First_Name varchar(15) NOT NULL,
Middle_Name varchar(10) NOT NULL,
DFD DATETIME NOT NULL,
DOB DATETIME NOT NULL,
DOD DATETIME NOT NULL,
Spouse varchar(15) NOT NULL,
Addr1 varchar(30) NOT NULL,
City varchar(20) NOT NULL,
State varchar(2) NOT NULL,
ZIP varchar(5) NOT NULL,
Phone varchar(20) NOT NULL,
PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id) )';
echo 'Creating table: $TB_Name...............';
mysql_query( $sql );
mysql_close($dbh);
?>
?>