include '/home/mmcom/dbfuncs.inc'; $name = $_POST['name']; $email = $_POST['email']; $conn = db_connect($host, $user, $dbpass); $query = "SELECT email from newsletter where email = '$email'"; $results = database_query($db, $query); if ($results == null){ die ("Had an SQL syntax error"); } // count number of matches $totalrows = mysql_num_rows($results); if ($totalrows < 1){ //if email not found adds it $query = "INSERT INTO newsletter (email, name) VALUES ('$email', '$name')"; $results = database_query($db, $query); if ($results == null){ die ("error3"); } } ?>