if( $submit ) { $link = mysql_connect("localhost", "patchn", "petite") or die("Could not connect"); mysql_select_db("patchn") or die("Could not select database"); $sql = "insert into people ( firstname, lastname, address, city, state, zip, country, email, comments, dateofsignup ) values ( '".mysql_escape_string( $fname )."', '".mysql_escape_string( $lname )."', '".mysql_escape_string( $address )."', '".mysql_escape_string( $city )."', '$state', '$zip', '".mysql_escape_string( $country )."', '$email', '".mysql_escape_string( $comments )."', Now() ) "; mysql_query( "delete from people where email = '$email' " ); mysql_query($sql) or die("Query failed$sql"); mysql_close($link); Header("Location:thanks.html" ); } ?>
|
||||||||||||