arkadaşlar php'de kayıt formu oluşturmaya çalışıyorum. phpmyadmin'den database oluşturdum fakat kayıt formunu doldurup submit dedikten sonra bu hatayı alıyorum. biraz araştırdım. database tablosunda primary key'i otomatik olarak üretmek lazımmış ama nasıl yapacağım bilemedim.
Field 'id' doesn't have a default value


ayrıca account type kısmını listbox şeklinde yaptım onu database nasıl aktaracağım.

http://i43.tinypic.com/6s59h4.png

register.php
<?php
if($_GET["regname"] && $_GET["regemail"] && $_GET["regpass1"] && $_GET["regpass2"] && $_GET["phone"] )
{
if($_GET["regpass1"]==$_GET["regpass2"])
{
$servername="localhost";
$username="root";
$conn= mysql_connect($servername,$username)or die(mysql_error());
mysql_select_db("bank",$conn);
$sql="insert into members (username,email,password,phone,type)values('$_GET[regname]','$_GET[regemail]','$_GET[regpass1]','$_GET[phone]','$_GET[type]')";
 
$result=mysql_query($sql,$conn) or die(mysql_error());
print "<h1>you have registered sucessfully</h1>";

print "<a href='index.php'>go to login page</a>";
}
else print "passwords doesnt match";
}
else print"invalid data";
?>

register.html

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>register</title>
</head>
<body bgcolor="white" style="color:black;">
<FORM ACTION="register.php" METHOD=get>
<h1>welcome to the registration page</h1>
please input the registration details to create an account here<br>
<table border="2">
<tr>
<td>Username :</td><td><input name="regname" type="text" size"20"></input></td>
</tr>
<tr>
<td>email :</td><td><input name="regemail" type="text" size"20"></input></td>
</tr>
<tr>
<td>password :</td><td><input name="regpass1" type="password" size"20"></input></td>
</tr>
<tr>
<td>retype password :</td><td><input name="regpass2" type="password" size"20"></input></td>
</tr>
<tr>
<td>Phone :</td><td><input name="phone" type="text" size"20"></input></td>
</tr>
<tr>
  <td>Account Type</td><td><select name="type" size="5">
  <option>Turkish Lira</option>
  <option>Euro</option>
  <option>Pound</option>
  <option>Dollar</option>
</select></td> 
</tr>
</table>
<input type="submit" value="Register"></input>
</FORM>
</body>
</html>