Insert data to MySql DB and display if insertion is success or failure

mysql, php

Solution

$result = mysql_query("INSERT INTO PEOPLE (NAME ) VALUES ('COLE')"));
if($result)
{
echo "Success";

}
else
{
echo "Error";

}

Problem

I am inserting data to a MySQL DB, In case if the insertion fails i need to give an appropriate error message indicating so. According to my code below i will be `Echo-ing` the message `Inserted` if the insertion was success or failure. What i want to do is to echo the `Inserted` message only when the data insertion is a success, and return `fail` if it fails. How can i modify my code to do so ? ``` <?php mysql_connect("localhost", "root", "123") or die(mysql_error()); mysql_select_db("swm_database") or die(mysql_error()); mysql_query("INSERT INTO PEOPLE (NAME ) VALUES ('COLE')")or die(mysql_error()); echo "Inserted"; ?> ```

Original source