Error in updating learner information

[hanspeare]

Hello everyone,

I am confused with these little codes why it keeps error in updating the learner information. These are my codes so far.
These are the bits of Student_Info.php which i think would be useful in my query.

<?php  if(!empty($_GET['flag']) && $_GET['flag'] == "success") { ?>   
        <span class="stylered style1"><span class="style5">Learner Information updated successfully.</span></span>  
        <?php } else if(!empty($_GET['flag']) && $_GET['flag'] == "error") { ?>
        <span class="stylered style3 style5"><span class="style1">Error while updating Learner Information. Please try again</span></span> 
        <?php }  ?>  </td>
 

This is the Student_Edit_Handler codes.

<?php
    session_start();
    $session_id = $_SESSION['user_id'];
    if($session_id == null){
       header("location:Student_Edit.php");
       die();
    }
    include 'Connect.php';
    $flag = "";
    $student_id = $_POST['student_id'];
    $first_name = $_POST['first_name'];
    $last_name = $_POST['last_name'];
    $gender = $_POST['gender'];
    $date_of_birth = date("Y-m-d",strtotime($_POST['date_of_birth']));
    $contact_no = $_POST['contact_no'];
    $grade  = $_POST['grade'];
    $section = $_POST['section'];
    $LRN = $_POST['LRN'];
    $email1 = $_POST['email1'];
    $email2 = $_POST['email2'];
    $address = $_POST['address'];
    $description = $_POST['description'];
    $query = "UPDATE student_information SET learner_id='$learner_id',first_name='$first_name',last_name='$last_name',";    
    $query .= "gender='$gender',date_of_birth='$date_of_birth',contact_no='$contact_no',grade='$grade',section='$section',";
    $query .= "LRN='$LRN',email1='$email1',email2='$email2',address='$address',description='$description'";     
    $query .= " WHERE student_id='{$_SESSION['user_id']}'";      
    $result = mysql_query($query, $link_id);
    if(mysql_error() != null){
        die(mysql_error());
        }
    else{
            $flag="error";
        }
        if($flag == "success"){
            mysql_query(" COMMIT ");
            $flag="success";
            if(mysql_error() != null){
                die(mysql_error());
            }
        }
    header("location:Student_Edit.php?flag=$flag&student_id='{$_SESSION['user_id']}'");   
?>
 

It flags the error on else{$flag="error";}

I am stuck with these codes guys, please do help me modify it so learner information will be update.

[Dormilich]

why it keeps error in updating the learner information.

and what are those errors?

[hanspeare]

hello dormilich,

thank you for the reply.
It dont give me any notifications but it wont just update.
But anyways, i already solve it my own dormilich.

See you in my next problem to encounter.