Jump to content

Incorrect table name


xagutxu

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.