Hello,
I am trying to fix my sql for error. It is showing a lot of syntax errors. Can you show me the errors. Rignt now it is saying:
Database error: Invalid SQL: CREATE TABLE autoresponders ( id int(11) NOT NULL auto_increment, from_email varchar(255) NOT NULL default '', subject varchar(100) NOT NULL default '', header text, body text, footer text, membership tinyint(2) NOT NULL default '0', days tinyint(2) NOT NULL default '0', count int(11) NOT NULL default '0', sent int(11) NOT NULL default '0', filter text', sendby tinyint(1) NOT NULL default '1', PRIMARY KEY (id) ) ENGINE=MyISAM AUTO_INCREMENT=17
MySQL Error: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 '', sendby tinyint(1) NOT NULL default '1', PRIMARY KEY (id) ) ENGINE' at line 12
Every time I fix an error, it shows me another.
Here is the autoresponders table
CREATE TABLE autoresponders (
id int(11) NOT NULL auto_increment,
from_email varchar(255) NOT NULL default '',
subject varchar(100) NOT NULL default '',
header text NOT NULL,
body text NOT NULL,
footer text NOT NULL,
membership tinyint(2) NOT NULL default '0',
days tinyint(2) NOT NULL default '0',
count int(11) NOT NULL default '0',
sent int(11) NOT NULL default '0',
filter text NOT NULL,
sendby tinyint(1) NOT NULL default '1',
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=17