bah counting error

[corruption]

so i'm having some troubles with a login script that i've modified. i fixed everything so far...i've changed the variables to fit what i want. so here is the error message i get:

Column count doesn't match value count at row 1

The login script is available for testing at http://www2.truman.edu/~d1514/members_area/join_form.html .

I can provide more information. Please help I'm trying to get a login script working for my website and am somewhat of a newb

I got the script from : http://www.phpfreaks.com/tutorials/40/2.php

[LordShryku]

Usually means you have either too many values or too little values in an insert query.
eg.

INSERT INTO table (field1, field2)
     VALUES ('value1','value2','value3')

or

INSERT INTO table (field1, field2)
     VALUES ('value1')