thi is wht i typed CREATE TABLE users(

user_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT ,
first_name VARCHAR( 15 ) NOT NULL last_name VARCHAR( 40 ) NOT NULL ,
email VARCHAR( 40 ) ,
PASSWORD CHAR( 16 ) NOT NULL ,
registration_date DATETIME NOT NULL ,
PRIMARY KEY ( user_id )
)


and got this any help

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'last_name VARCHAR(40) NOT NULL,
email VARCHAR(40),
password C

PHP Code:

CREATE TABLE `users` (
 `user_id` MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT ,
 `first_name` VARCHAR( 15 ) NOT NULL ,
 `last_name` VARCHAR( 40 ) NOT NULL ,
 `email` VARCHAR( 40 ) NOT NULL ,
 `PASSWORD` CHAR( 16 ) NOT NULL ,
 `registration_date` DATETIME NOT NULL ,
 PRIMARY KEY ( `user_id` )
 ) TYPE = MYISAM ; 


thats what it should be

PHP Code:

             $sql  = 'CREATE TABLE `users` ('
          . '   `user_id` MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, '
          . '   `first_name` VARCHAR(15) NOT NULL, '
          . '   `last_name` VARCHAR(40) NOT NULL, '
          . '   `email` VARCHAR(40) NOT NULL, '
          . '   `PASSWORD` CHAR(16) NOT NULL, '
          . '   `registration_date` DATETIME NOT NULL,'
          . '   PRIMARY KEY (`user_id`)'
          . ' )'
          . ' TYPE = myisam'; 


and there it is in php coding for pages

hi what the bottom one for also ive done that what are the ` these for and what button get them when do i knwo where to put them