Have you tried using the MS Query Analyzer? Run your update in it and see what happens. It looks to me like your insert statement should be INSERT INTO prodreg VALUES ($stmt), rather than INSERT INTO prodreg SET ($stmt); I'm no SQL wizard though.