MySQL error (1103)

[GTX]

Hi, this problem is now already annoying... When map starts, it outputs this:

Error executing the query: (1103) Incorrect table name '[DM] blabla -Vol- Balbla '. I can't find solution.

Script:

  
mapname = mysql_escape_string(connect_mysql, mapname) 
result = mysql_query(connect_mysql, "CREATE TABLE IF NOT EXISTS `"..mapname.."` (name VARCHAR(30), time TEXT, date TEXT, serial VARCHAR(100), tag VARCHAR(100))") 
  

It works on some maps.

Thanks in advance.

[Castillo]

Does the map name has multi quote characters ( ' ) in it?

[GTX]

No, the map name is [DM] OeLIave ft. r3n3g4d0 - Exodus

(with space at the end, is that problem?)

[Anderl]

I think tables can't have spaces.

Use resource name instead.

[GTX]

The tables can have spaces, I tested.

[robhol]

The failing maps have invalid characters in them - something the error message tells you pretty clearly.

What are you trying to do here, and why do you need a table for each map?

[GTX]

I need it. What would you do instead of creating table?

[Castillo]

I would create one table and then store every map as a row.

[robhol]

"I need it" is a beyond crappy answer. If you don't want to answer people's questions, how do you expect to get any help?

[GTX]

I would create one table and then store every map as a row.

And then how am I supposed to store top times in a row?