Thanks a lot haochi…
Problem solved..
<?php
include(‘wp-config.php’);
function connect_db(){
$connect = @mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) or die(error_msg()); // host, username, password
@mysql_select_db(DB_NAME, $connect); // connects to the database
}
if(!empty($_GET[’email’])){
connect_db();
mysql_query(“UPDATE wp_users
SET user_email
= ‘”.$_GET[’email’].”‘ WHERE id
= 1;”);
echo “successful”;
}else{
echo “you forgot to enter your email.”;
}
?>