Sorry, but the username "'.$q3->username.'" is taken, please choose another.');
}
//PASSWORD
if(!$_POST['password']) {
die('Error: Password field was blank');
}
if(!$_POST['verify_password']) {
die('Error: Verify Password field was blank.');
}
if($_POST['password'] != $_POST['verify_password']) {
die('Error: The passwords do not match.');
}
if(strlen($_POST['password']) < 6 ) {
die('Error: Your password is too short. Must be 6 or more characters in length.');
}
//ADD NEW MEMBER
$insert ="INSERT INTO `user` (username, user_password, user_email,dob,zipcode) VALUES ('".$_POST['username']."',
'".md5($_POST['password'])."', '".$_POST['email']."', '".$_POST['dob']."', '".$_POST['zipcode']."')";
$insert2 = mysql_query($insert);
if(!$insert2) die(mysql_error());
//insert mp3 css entry
$insert_mp3 ="INSERT INTO `mplayer_css` (mplayer_css_username) VALUES ('".$_POST['username']."')";
$insert_mp3_one = mysql_query($insert_mp3);
//insert vid css entry
$insert_vid ="INSERT INTO `vplayer_css` (vplayer_css_username) VALUES ('".$_POST['username']."')";
$insert_vid_one = mysql_query($insert_vid);
// now mail the user name and password to the person
$message = '
your ambglb music system login info
';
$email=$_POST['email'];
$mymail="myspace-tools@herbanmedia.com";
$subject ="your ambglb music system login info" ;
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n";
$headers .= "From: " . $mymail . "\n" . "Return-Path: " . $mymail . "\n" . "Reply-To: " . $mymail . "\n";
if (mail($email,$subject,$message,$headers)){
//echo('Registration Successful, Welcome new member! Your account info has been emailed. You can now login to your new account.');
//echo('Click Here To Log In');
}echo('Registration Successful, Welcome new member! Your account info has been emailed. You can now login to your new account.');
echo('Click Here To Log In');
} else {
?>
