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