MySQL Query problem

[stevieboy_ca]

I've been trying to run this query but am having no luck, I'm hoping someone can spot my mistake...The query is

insert into 'case' (case_id, submit_date, priority, heading, description, submited_by, assigned_to, computer_sys, closed_by, close_date, require_by, open) VALUES(NULL, '2003-03-18 10:57:00', 3, 'Test', 'Test Desc...', 'user1', 'user2', 'PC1', NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1)

The fields description, assigned_to, closed_by, close_date, and require_by can be NULL values.

[LordShryku]

if it's null, dont try to insert it....

insert into case
(submit_date, priority, heading, description, submited_by, assigned_to, computer_sys, close_date, require_by, open)
VALUES('2003-03-18 10:57:00', '3', 'Test', 'Test Desc...', 'user1', 'user2', 'PC1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1')