what's wrong with this MySQL statement?

[seanpaulcail]

here's my table building statement

create table Eli
( 
page_number int not null auto_increment primary key, 
num_of_sm_images int char(3), 
big_image_name char (30), 
page_text text 
);

here's my error message

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 'char( 3  ) , big_image_name char( 30  ) , page_text text )' at 

I'm confused. This should be easy.
What am I doing wrong?😕

Thanks

[superwormy]

THis: num_of_sm_images int char(3),

You're defining an INT field then redefining as CHAR(3). Why? You need to choose either INT or CHAR type.

[seanpaulcail]

I knew it was something simple.

Thanks again