Syntax error

[Ameno]

Anyway.. i have this problemo..


PHP Code:
$CreateTables = "CREATE TABLE 'administrator' (
'uname' VARCHAR( 15 ),
'pword' VARCHAR( 15 ),
'email' VARCHAR( 50 ),
'lastlogin' VARCHAR( 25 )
)

CREATE TABLE 'files' (
'id' INT( 5 ) AUTO_INCREMENT ,
'filename' VARCHAR( 50 ),
'size' VARCHAR( 50 ),
'mime' VARCHAR( 50 ),
'created' VARCHAR( 50 ),
'lastedit' VARCHAR( 50 ),
PRIMARY KEY ( 'id' )
)

CREATE TABLE 'history' (
'id' INT( 5 ) AUTO_INCREMENT ,
'filename' VARCHAR( 50 ),
'created' VARCHAR( 50 ),
'lastedit' VARCHAR( 50 ),
'action' VARCHAR( 50 ),
PRIMARY KEY ( 'id' )
)
";
$CreateQuery = mysql_query($CreateTables);

Quote:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''administrator' ( 'uname' VARCHAR( 15 ), 'pword' VARCHAR( 15 ), 'email' VARCH' at line 1

i have no idea how to fix it..
maybe someone can help me
_________________
free website business (http://www.websitewealth.ws) play mystery games (http://www.shabugames.com/genres/Mystery/index.html)