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