Re: Syntax Problem
Posted by:
Usama Ali
Date: May 13, 2005 05:45PM
Hey... Thanks for helping out...
This is the SQL. Generated by phpMyAdmin.
I have a feeling this all has to do with my form though. As you will see, I have changed all variable names (fields) to be varchars. I thought that it might be a 'field type' problem that I'm having.
Any thoughts anyone may have will be of great help.
CREATE TABLE `attendee` (
`ATTENDEE_ID` int(4) NOT NULL auto_increment,
`vcu_alumni` varchar(50) default NULL,
`salutation` varchar(6) NOT NULL default 'Mr.',
`first_name` varchar(25) NOT NULL default '',
`middle_initial` char(2) default NULL,
`last_name` varchar(25) NOT NULL default '',
`suffix` varchar(10) default NULL,
`nickname` varchar(20) default NULL,
`profession` varchar(50) NOT NULL default '',
`profession_other` varchar(50) default NULL,
`business_market_interested_primary` varchar(50) NOT NULL default 'Richmond',
`business_market_interested_secondary` varchar(50) default NULL,
`title` varchar(50) default NULL,
`organization` varchar(100) NOT NULL default '',
`organization_name_other` varchar(100) default NULL,
`address` varchar(50) default NULL,
`city` varchar(50) default NULL,
`state` varchar(50) default 'Virginia',
`zipcode` varchar(10) NOT NULL default '',
`country` varchar(50) default NULL,
`workphone` varchar(14) default NULL,
`fax` varchar(14) default NULL,
`mobilephone` varchar(14) default NULL,
`email` varchar(80) default NULL,
`picture_permission` varchar(6) NOT NULL default 'Yes',
`sponsorship_status` varchar(6) default NULL,
`rece_member` varchar(6) default NULL,
`cc_member` varchar(6) default NULL,
`vcu_faculty_staff` varchar(6) default NULL,
`notes` text,
PRIMARY KEY (`ATTENDEE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;