Oh, sorry . . . yes, I'd tried it before as well, but I just tried it again:
PHP Code:
$sqldrop = "DROP TABLE $daydata";
$sqlreset = "CREATE TABLE '".$daydata."' ('id' tinyint(4) NOT NULL auto_increment, 'start_time' int(11) NOT NULL default '0', 'end_time' int(11) NOT NULL default '0', 'time_label' text NOT NULL, 'name' text NOT NULL, 'image' text NOT NULL, 'info_link' text NOT NULL, PRIMARY KEY ('id')) TYPE=MyISAM";
$sqlinsert = "INSERT INTO '".$daydata."' SELECT * FROM '".$daydata."_Template'";
Resulting in this:
You have an error in your SQL syntax near ''Friday' ('id' tinyint(4) NOT NULL auto_increment, 'start_time' int(11) NOT NULL' at line 1