Incorrect table name

[xagutxu]

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

[PFMaBiSmAd]

using the same $table variable

 

^^^ Not.

[Muddy_Funster]

...

$query = "CREATE TABLE `dbchat`.`".$table."` (";

...

 

$query = "CREATE TABLE `dbchat`.`".$taula."online"."` (";

...