Untitled

<?php
$con = mysql_connect("localhost","ccs1119a_23","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

$sex = $_POST["sex"];
$username = $_POST["un"];
$password = $_POST["pw"];
$firstname = $_POST["fn"];
$lastname = $_POST["ln"];
$Date = $_POST["day"]." ".$_POST["month"].", ".$_POST["year"]; // January 31, 2012

mysql_select_db("ccs1119a_23", $con);

$sql="INSERT INTO register3 (Username, Password, FirstName, Lastname, date, sex)
VALUES
('".$firstname."','".$lastname."','".$username."','".$password."','".$Date."','".$sex."')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";

mysql_close($con);


?>


<html>
<body>

<form action="register2.php" method="POST">
Username: <input type="text" name="un" /><br>
Password: <input type="password" name="pw" /><br>

Firstname: <input type="text" name="fn" /><br>
Lastname: <input type="text" name="ln" /><br>
Sex: <select name="sex"><br>
	<option>Male</option>
	<option>Female</option>
	</select>

Date of Birth:
	<select name="day"><br>
	<option>1</option>
	<option>2</option>
	<option>3</option>
	<option>4</option>
	<option>5</option>
	<option>6</option>
	<option>7</option>
	<option>8</option>
	<option>9</option>
	<option>10</option>
	<option>11</option>
	<option>12</option>
	<option>13</option>
	<option>14</option>
	<option>15</option>
	<option>16</option>
	<option>17</option>
	<option>18</option>
	<option>19</option>
	<option>20</option>
	<option>21</option>
	<option>22</option>
	<option>23</option>
	<option>24</option>
	<option>25</option>
	<option>26</option>
	<option>27</option>
	<option>28</option>
	<option>29</option>
	<option>30</option>
	<option>31</option>
	</select>

	<select name="month"><br>
	<option>january</option>
	<option>february</option>
	<option>march</option>
	<option>april</option>
	<option>may</option>
	<option>june</option>
	<option>july</option>
	<option>august</option>
	<option>september</option>
	<option>october</option>
	<option>november</option>
	<option>december</option>
	</select>

	<select name="Year"><br>
	<option>2013</option>
	<option>2012</option>
	<option>2011</option>
	<option>2010</option>
	<option>2009</option>
	<option>2008</option>
	<option>2007</option>
	<option>2006</option>
	<option>2005</option>
	<option>2004</option>
	<option>2003</option>
	<option>2002</option>
	<option>2001</option>
	<option>2000</option>
	<option>1999</option>
	<option>1998</option>
	<option>1997</option>
	<option>1996</option>
	<option>1995</option>
	<option>1994</option>
	<option>1993</option>
	<option>1992</option>
	<option>1991</option>
	<option>1990</option>
	</select>


<br><input type="submit" value="submit" />
</form>

</body>
</html>