insert syntax error

Hi I have this insert statement

insert into useraccount
(user_id,acc_id,acc_type_id,acc_bal,acc_open_date, acc_status,loan_amount)
SELECT 2,acc_id,3,5000,curdate(),1,5000
FROM dual
WHERE NOT EXISTS
(select * from useraccount where useraccount.user_id =2 and useraccount.acc_type_id=3);

It is basically if the acc_type_id = 3 record doesn't exists then it should insert otherwise it should not insert. But it gives me error in the query, can anyone help me out.

You should check which version of MySQL you are using. subqueries in the WHERE clause were not introduced until version 4.1, which is currently only a Beta release.
You might have derived this code from SQL, where is has been available much longer.