Creating table in MySQL?

[Jockie]

I'm currently stuck with a tiny problem, I want to save every race map name into the database with accountname+stats.

But the thing is, it does nothing.

No errors in the debugscript, no overheaded data at database.

fullname = "test" -- fullname is the name of the map(from a map table) 
--MySQL > Connection to the database, that works. ;D 
  
mysql_query( MySQL, "CREATE TABLE '<databasename>."..fullname.."' ( id INT( 11 ) NOT NULL , name VARCHAR( 255 ) NOT NULL , latest VARCHAR( 255 ) NOT NULL , played VARCHAR( 255 ) NOT NULL , won VARCHAR( 255 ) NOT NULL , latest1 VARCHAR( 255 ) NOT NULL , played1 VARCHAR( 255 ) NOT NULL , won1 VARCHAR( 255 ) NOT NULL , latest2 VARCHAR( 255 ) NOT NULL , played2 VARCHAR( 255 ) NOT NULL , won2 VARCHAR( 255 ) NOT NULL )") 
mysql_query( MySQL, "ALTER TABLE "..fullname.." ADD PRIMARY KEY ( id )")  
mysql_query( MySQL, "ALTER TABLE "..fullname.." CHANGE id id INT( 11 ) NOT NULL AUTO_INCREMENT  ") 

[dzek (varez)]

check what first mysql_query is returning.

I don't remember how to get error of query in mta but the query is invalid.

also you should create table once, so CREATE TABLE IF NOT EXISTS will be better.

I suggest you to get back to mysql manual.

your table logic isn't good one to. columns like "won" should be int i think.

summary: read manual, re-think that again and rewrite from scratch

[Jockie]

I found the problems, those are the "[", "]", "" and "-" in the name.

Like [DM] Pr0nOoB - Summer Beach

So how to make is saveable and that the "[", "]", "" and "-" will save?

[dzek (varez)]

i dont understand.

first thing that is incorrect is this: "." - you can simply remove it