mysql_error should be useful here -
PHP: mysql_error - Manual
You don't appear to be doing any cleaning or validation on your data leaving yourself open to SQL injection.
I suspect it the error will be due to apostrophes or special characters in your input. If magic_quotes was previously set to on these would have been escaped properly. See
Apostrophies in text boxes creating mysql error
Ben