doesnt submit data to database
Posted: Fri Jun 03, 2005 7:01 pm
for some reason when you register for my game it connects but it doesnt send the data to the database or send the person an email.
here is my code
sorry for asking so many questions about mysql, im very new to it.
thanks,
matt
here is my code
Code: Select all
<?PHP
require('dblink.php');
//mysql query
$query = 'INSERT INTO member (Username, Password, Email Address, First Name, Last Name, Sex, Date of Birth, City, Country) VALUES ("'.$_POST[Username].'", "'.$_POST[Password].'", "'.$_POST[Email].'")';
$db_query = mysql_query($query);
$to = $_POST['Email'];//the email address the user submitted
$subject = 'You Registered!';
$message = 'You have just registered to play on The Streets. To log in go to the main page and use your username and password to sign in.';//the body of the email you are sending
mail($to, $subject, $message);//mail sent
?>thanks,
matt