[RESOLVED] Unsuccessful Update

[devil_vin]

Hi..guys!I have written a script to update form data but seems not work at all.😕

<?php

$tbl_name = "member";
if (isset($_POST['update'])) {
    $update = mysql_query("
            UPDATE 
		        $tbl_name
             SET
		 name = '" . mysql_real_escape_string($_POST['name']) . "',
		 telephone = '" . mysql_real_escape_string($_POST['phone']) . "',
		 address = '" . mysql_real_escape_string($_POST['address']) . "'
		     WHERE
		 name =  '" . mysql_real_escape_string($_REQUEST['name']) . "',
	     telephone = '" . mysql_real_escape_string($_REQUEST['telephone']) . "',
		 address = '" . mysql_real_escape_string($_REQUEST['address']) . "'
	      ");


    //echo($update);
    //exit();
    $updatedResult = mysql_query($update) or die(mysql_error());



    if (mysql_affected_rows() == 1) {
?>
         <script type="text/javascript">
         alert("Your profile already updated.");
         history.back();
         </script>
    <?php

        //THIS CODE IS UNCOMMENTED
        //So that people without JS can still see the message.
        die("Your profile already updated");
        //END
    }

}
}
?> 		

[devil_vin]

Problem resolved.

<?php

$tbl_name = "member";
if (isset($_POST['update'])) {
    $update = "
            UPDATE 
		        $tbl_name
             SET
		 name = '" . mysql_real_escape_string($_POST['name']) . "',
		 telephone = '" . mysql_real_escape_string($_POST['phone']) . "',
		 address = '" . mysql_real_escape_string($_POST['address']) . "'
		     WHERE
		 email =  '" . $_SESSION['gmemberid'] . "'";


    //echo($update);
    //exit();
    $updatedResult = mysql_query($update) or die(mysql_error());



    if (mysql_affected_rows() == 1) {
?>
         <script type="text/javascript">
         alert("Your profile already updated.");
         history.back();
         </script>
    <?php

        //THIS CODE IS UNCOMMENTED
        //So that people without JS can still see the message.
        die("Your profile already updated");
        //END
    }

}
}
?>