\[code\] $sql = "UPDATE `$db_name`.`$tbl_name` SET `u_code` = '$u_code' WHERE `$tbl_name`.`email` = `$mail`;"; $result=mysql_query($sql);\[/code\]Whenever an email id (eg: [email protected]) is entered and the query is run then error occurs (No such e-mail exists in the database , Although it is present)but after some experiments it is found that instead of entering the email-id (eg: [email protected]) the word "email" is entered and the query is run...it works..but at the same time disturbs whole column {u_code} by changing the value to $u_code for all the database present.So the problem seems to be in the MySQL query....but I can figure it out. Thanks for the help! 