Mysql and Php Programming

What are the possible reasons for the a record not to be inserted into a database on a mysql server even after connection to the server was successful.