|
Perhaps I should also post this . . . this is the readout created when the function is executed correctly through phpmyadmin. I've replaced the database name with DATABASENAME, as it would give away something about the site I'm not allowed to, but other than that it's verbatim.
I have tried to rephrase the query with these 'DATABASENAME'. extensions with still no luck. I originally trimmed them out because of this line in my own code:
mysql_select_db('databasename',$lnk);
CREATE TABLE `DATABASENAME`.`Friday` (
`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 ;
INSERT INTO `DATABASENAME`.`Friday`
SELECT *
FROM `DATABASENAME`.`Friday_Template`
|