How to know record has been updated successfully in php

Question

$sql = "UPDATE....";

if(mysql_query($sql))
    {
        $_SESSION['Trans']="COMMIT";
        header("location:result.php");
        exit;
    }
    else 
        {
            $_SESSION['Trans']="FAIL";
            $_SESSION['errors'] = "Error: Sorry! We are unable to update your Profile, Please contact to PNP HelpDesk.";
            header("location:result.php");
            exit;
        }//end  IF

data is getting updated then why compiler is not coming inside IF condition.

Answer 1

mysql_query only returns FALSE on an error condition, rather than if no rows have been updated.

To see if anything has been updated, use mysql_affected_rows, e.g.:

$sql = 'UPDATE ....';
mysql_query($sql);
if (mysql_affected_rows() > 0) { 
  // Success
} else {
  // Failure
}