#1064 - You have an error in your SQL syntax; check the manual that corresponds to yo

[edmanhickman]

Hi all
I am trying to make 2 tables on my database rsvp i am using mysql version 5.5.16 our professor told us to use this scripts to create tables in our database and i am getting this 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 '=MyISAM AUTO_INCREMENT=1' at line 12
DROP TABLE IF EXISTS `rsvps`;
CREATE TABLE IF NOT EXISTS `rsvps` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`firstname` varchar(255) NOT NULL,
`lastname` varchar(255) NOT NULL,
`phone` int(10) NOT NULL,
`email` varchar(255) NOT NULL,
`attending` varchar(255) NOT NULL,
`guest` varchar(255) NOT NULL,
`foodchoice` varchar(255) NOT NULL,
`comments` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
TYPE=MyISAM AUTO_INCREMENT=1 ;
also i need table script for an upload image from my rsvp i know the one he gave us is wrong because just about every code he has given us is wrong lol i would appreciate any help you'll can give

[r937]

our professor told us to use this scripts

your professor gave you code with errors in it

first of all, you're missing the closing parenthesis for the list of columns

this one --> CREATE TABLE tablename ( list of columns ) table attributes

secondly, one of your table attributes is from an earlier version of mysql and will also give you an error