添加一个表示RECORDS UPDATED的脚本

Question

I have code that updates the student records.

$select_query="select student_id from student_information where student_id = '$student_id'";
$result_set = mysql_query($select_query,$link_id);

if($row = mysql_fetch_array($result_set)){
    $flag="exists";
    header("location:Admin_Home.php?flag=$flag&student_id=$student_id");
    die();
}
else{
    /*
        This block is used to insert the learners record in database 
        if the student_id is not yet registered in the database. 
    */
    mysql_query("SET AUTOCOMMIT = 0 ");
    if(mysql_error() != null){
        die(mysql_error());
    }
    $query = "insert into student_information(student_id,student_password,first_name,last_name,registration_date,gender,date_of_birth,";
    $query .= "contact_no,grade,section,LRN,email1,email2,address,description,learner_id)";
    $query .= " values('$student_id','$student_password','$first_name','$last_name',now(),'$gender','$date_of_birth',";
    $query .= "'$contact_no','$grade','$section','$LRN','$email1','$email2','$address','$description','$learner_id')";
    $result = mysql_query($query,$link_id);
    if(mysql_error() != null){
        die(mysql_error());
    }
}

Now, my problem is to put a script that alerts that the "records has been updated" and from what part of this code be it inserted. Please advise.

Answer 1

Change this:

if(mysql_error() != null){
    die(mysql_error());
}

To this:

if (mysql_error() != null) {
    die(mysql_error());
}
echo "Records updated.";