pomader

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
_________________
simulation games georgia fha refinance

kickass

According to the message i can't see any of the error in your table make sure that your table syntax is correct and try to create it again and if there is no solutions you are getting or you feel that you have forgot some of the codes then i think you should simply go to the website w3schools for further information.

abby981

check out the semicolons u used...