Not sure what I am doing wrong here but when I create a mysql table the table is created but when I enter the information into the fields and it populates the table it is skipping records. It will create a table with IDs of 1 then 3 then 5 then 7 and so on. Here is the code I am using to create my table:

<?php include ("db_connect.php"); ?>
<?php
//select the database in which to add a table
mysql_select_db("final_exam_db",$con);
$sql = "CREATE TABLE tablename
(id int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
fn varchar(15),
ln varchar(15),
month varchar(9),
day int,
year int,
photo varchar(30),
email varchar(40)
)";
mysql_query($sql,$con);
echo mysql_error();
?>
<?php include ("db_close.php"); ?>

Thank you in advance.