I know nothing about this but am trying to create a table - can anyone see
whats wrong?
-----------------
Error
SQL-query :
CREATE TABLE journal(
'journalid'int( 11 ) NOT NULL AUTO_INCREMENT ,
'title'text NOT NULL ,
'description'text NOT NULL ,
'imagename'text NOT NULL ,
'entries'int( 11 ) NOT NULL default '0',
'views'int( 11 ) NOT NULL default '0',
'enabled'smallint( 6 ) default '0',
'timestamp'int( 11 ) NOT NULL default '0',
'userid'int( 11 ) NOT NULL default '0',
'mood'text NOT NULL ,
'np'text NOT NULL ,
PRIMARY KEY ( 'journalid' )
) TYPE = MYISAM
MySQL said:
#1064 - 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
''journalid'int( 11 ) NOT NULL AUTO_INCREMENT ,
'title'text
