I'm creating my own website and I want to let users to register and log in and to take a quiz this is the code that I have put in for the query in phpmyadmin
- Code: Select all
CREATE DATABASE `dyscaculia` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
USE `dyscaculia`;
CREATE TABLE IF NOT EXISTS `users` (
`Firstname` varchar(99) DEFAULT NULL
`Lastname` varchar(99) DEFAULT NULL
`Username` varchar(99) DEFAULT NULL
`Email` decimal(99) DEFAULT NULL
`ConfirmEmaill` varchar(99) DEFAULT NULL
`Password` varchar(99) DEFAULT NULL
`PasswordEmaill` varchar DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
when I run the query this is the error message that I'm getting
#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 '`Lastname` varchar(99) DEFAULT NULL
`Username` varchar(99) DEFAULT NULL
`' at line 3
can someone please help me out with this asap
thanks for any help
rich