<?php
$host="localhost"; // Host name
$username="socnet"; // Mysql username
$password="socnet"; // Mysql password
$db_name="registered_inn_keepers"; // Database name
$tbl_name="members"; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// Get values from form
$my_username=$_POST['textarea23312'];
$my_password=$_POST['textarea23310'];
$my_password_confirm=$_POST['textarea2339'];
$my_email_id=$_POST['textarea23311'];
$my_real_name=$_POST['textarea233'];
$my_address=$_POST['textarea2322'];
$my_city=$_POST['textarea2332'];
$my_state=$_POST['textarea2333'];
$my_phone_number=$_POST['textarea2335'];
$my_twitter_account=$_POST['textarea2336'];
$my_inns_name=$_POST['textarea2337'];
$my_inn_website=$_POST['textarea2338'];

if ($my_password = $my_password_confirm){
$sql1="SELECT * FROM $tbl_name WHERE username='$my_username' and password='$my_password'";
$result1=mysql_query($sql1);
$count=mysql_num_rows($result1);

if($count==0){
// Register...
$sql2="INSERT INTO $tbl_name(username, password, email_id, real_name, address, city, state, phone_number, twitter_account, name_of_inn, inn_website)VALUES('$my_username', '$my_password', '$my_email_id', '$my_real_name', '$my_address', '$my_city', '$my_state', '$my_phone_number', '$my_twitter_account', '$my_inns_name', '$my_inn_website')";
$result2=mysql_query($sql2);
}
else {
header("location:signup_error.php");
}
if($result2){
// if registration successful, so i need to put this in an if clause
 $subject = "Here are your account details.";
 $message = "Hi,\n\nYou have successfully registered with Bread & Breakfast Stay. \n\nHere is your login information. \n\nUsername: $my_username \n\nPassword: $my_password \n\nWe reccommend new users to please login and check if everything is in order. \n\nThank you. \n\nHave a nice day!\nBed And Breakfast Stay Team";
 $to = $my_email_id;
 mail($to,$subject,$message);
 echo "Mail Sent.";
}
else {
 header("location:signup_error.php");
}
}
// close connection
mysql_close();
?>