Insert doesn't do what it's supposed to
 

I have a ton of inserts in an sql file that look like this:

INSERT INTO grades (GWid, classid, semester, year, grade, required) 

VALUES(100000089, 'CS210', 'B', 'fall', '2006', 'yes');

but when I get my filled tables, the semester and grades are all null and the year is 0000. Any explanations as to why this would be happening?

I'm using phpMyAdmin 2.6.4-pl4 with MySQL 3.23.32 (maybe higher). It's on a university server so I don't have any choice in the matter or privileges to change anything.
-----------------------

Crap, I just realised that the values are in the wrong order. Problem solved. Tiiiiired...

Re: Insert doesn't do what it's supposed to
 

Your declared column names and values don't line up correctly. Try this:

INSERT INTO grades (GWid, classid, semester, year, grade, required) 

VALUES(100000089, 'CS210', 'fall', '2006', 'B', 'yes');