I just couldn't insert data into database
so there must be thing wrong with my code
could somebody take look for me thank you
PHP Code:
<? 
------------------build database.php-----------------------
//this the table information 
 $aSQL = "create table user (userID  integer not null auto_increment,
                             firstName   char(35),
                             lastName    char(35),
                             userName    char(20),
                             password    char(10),
                             eMail       char(30),
                             fColor      char(15),
                             fAnimals    char(20),
                             fEngine     char(50),
                             primary key (userID),
                             foreign key (newsSiteID) references newsSite (newsSiteID))";
--------------------comfirm_register.php ----------------------------

$theFirstName = $_POST['theFirstName'];
$theLastName  = $_POST['theLastName'];
$theUserName  = $_POST['theUserName'];
$thePassword1 = $_POST['thePassword1'];
$thePassword2 = $_POST['thePassword2'];
$theEmail     = $_POST['theEMail'];
$theFColor    = $_POST['theFColor'];
$theFAnimals  = $_POST['theFAnimals'];
$theEngine    = $_POST['theEngine'];
$theNewsSite  = $_POST['theNewsSite'];

//some errors checking here

$aSQL = mysql_query("INSERT INTO user VALUES(null,'$theFirstName','$theLastName','$theUserName','$thePassword','$theEMail','$theFColor','$theFAnimals' '$theEngine')")
                    or die (mysql_error());
?>
Error messege: Column count doesn't match value count at row 1