xagutxu Posted May 30, 2011 Share Posted May 30, 2011 Hi! I create a Table within a connexion in mySQL: $query = "CREATE TABLE `dbchat`.`".$table."` ("; $query .= "`line_id` INT(11) NOT NULL AUTO_INCREMENT, "; $query .= "`line_txt` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, "; $query .= "PRIMARY KEY (`line_id`)) ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;"; mysql_query($query,$con) or die(mysql_error()); And, after that, I try to create another table, using the same $table variable, but attaching "_online": $query = "CREATE TABLE `dbchat`.`".$taula."online"."` ("; $query .= "`usr_id` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, "; $query .= "`usr_time` INT(11) NOT NULL, "; $query .= "PRIMARY KEY (`usr_id`)) ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;"; mysql_query($query,$con) or die(mysql_error()); But I obtain the next error: Incorrect table name 'xxxxxxxxxx_online' Any help...? Thank you, Xagutxu Link to comment https://forums.phpfreaks.com/topic/237913-incorrect-table-name/ Share on other sites More sharing options...
PFMaBiSmAd Posted May 30, 2011 Share Posted May 30, 2011 using the same $table variable ^^^ Not. Link to comment https://forums.phpfreaks.com/topic/237913-incorrect-table-name/#findComment-1222609 Share on other sites More sharing options...
Muddy_Funster Posted May 31, 2011 Share Posted May 31, 2011 ... $query = "CREATE TABLE `dbchat`.`".$table."` ("; ... $query = "CREATE TABLE `dbchat`.`".$taula."online"."` ("; ... Link to comment https://forums.phpfreaks.com/topic/237913-incorrect-table-name/#findComment-1222824 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.