Okay- I got it to work by using the following below:
[pre]but I still get an error message:?
ERROR CREATE PROJECT :Unknown column 'number_of_questions' in 'field list'[/pre]
this is what I have now:
CREATE TABLE `account` (
`account_id` int(20) NOT NULL auto_increment,
`username` varchar(255) NOT NULL default '',
`password` varchar(255) NOT NULL default '',
`create_date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`account_id`)
);# MySQL returned an empty result set (i.e. zero rows).
CREATE TABLE `project` (
`project_id` int(20) NOT NULL auto_increment,
`account_id` int(20) NOT NULL default '0',
`project_name` varchar(255) NOT NULL default '',
`admin_email` varchar(255) NOT NULL default '',
`autoresponder_email` varchar(255) NOT NULL default '',
`number_of_Answers` int(11) NOT NULL default '0',
`Answers` text NOT NULL,
`create_date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`project_id`)
) ;# MySQL returned an empty result set (i.e. zero rows).
CREATE TABLE `stats` (
`project_id` int(20) NOT NULL default '0',
`account_id` int(20) NOT NULL default '0',
`question_id` int(20) NOT NULL default '0',
`ip` bigint(20) NOT NULL default '0',
`answered` int(20) NOT NULL default '0',
`converted` int(20) NOT NULL default '0',
`date` datetime NOT NULL default '0000-00-00 00:00:00'
) ;# MySQL returned an empty result set (i.e. zero rows).
Thanks- Again..
TRUSTINWEB