ok have found this script from what i can understand from reading it you fill out form then it emails you to activate then inserts the data into database can any one help me out with this as this seems to be what i need to verify email addy <?php include ('inc/header.php'); if(isset($_POST['submit'])){ $postfname = $_POST['firstname']; $postlname = $_POST['lastname']; $postuser = $_POST['username']; $postpass = md5($_POST['password']); $postpass2 = md5($_POST['confirmpassword']); $postemail = $_POST['email']; $postemail2 = $_POST['confirmemail']; $postphone = $_POST['phone']; $postloca = $_POST['location']; $postweb = $_POST['website']; if(($postpass != $postpass2) || ($postemail != $postemail2)){ header('location: register.php?error=Fields do not match'); } else { $check = mysql_query("SELECT * FROM users WHERE lower(username) = lower('$postuser')")or die(mysql_error('Sorry couldnt find you in the database.')); $rowcount = mysql_num_rows($check); if ($rowcount >= 1) { header("location: register.php?error=Username already taken"); } $query = "INSERT INTO users (username, password, firstname, lastname, email, phone, location, website) VALUES ('$postuser', '$postpass', '$postfname', '$postlname', '$postemail', '$postphone', '$postloca', '$postweb')"; $result = @mysql_query($query); $to = $postemail; $subject = "Caravan Holiday Exchange Activation"; $message = "Thank you, $postuser.<br><br> Please active by click the link below:<br><br> <a href='http://www.***********/register.php?active=1&user=$postuser'> http://www.*********/register.php?active=1&user=$postuser</a><br><br> Thank you,<br> C*************"; include('inc/mail.inc'); } PHP: