Book to SQL not working?

I have the book Headfirst PHP & MySQL... now I'm already frustrated on a few things they are teaching me, but I am looking at page 64 of the book, it gives me a code command to write into phpMyAdmin.

My service is hostgator, and as far as I can tell they are using MySQL 5.5...

It the book it tells me to write this code to send to the database;

Create Table aliens_abduction ( 
first_name varchild (30),
last_name varchild (30),
when_it_happened varchild (30),
how_long varchild (30),
how_many varchild (30),
alien_description varchild (100),
fang_spotted varchild varchild (10),
other varchild (100),
email varchild (50),
);

Code (markup):

When entering it into phpMyAdmin, I get this error:

Any idea what is going on and why?

By all intended purposes I am doing this correctly... at least by the book.

 

it shd be like this


Create Table aliens_abduction (
first_name varchar (30),
last_name varchar (30),
when_it_happened varchar (30),
how_long varchar (30),
how_many varchar (30),
alien_description varchar (100),
fang_spotted varchild varchar (10),
other varchar (100),
email varchar (50),
);

I hope it helps

Regards

Alex

 

Still get the same error...

 

fang_spotted varchild varchar (10),

should be

fang_spotted varchar (10),

I don't know where you got "varchild", but it should be "varchar". There's no "varchild" in SQL.

 

probably a typo that the program corrected by mistake... thanks though.

 

varchild
It should be varchar ..