#5
Du skal starte med at designe din database, du har hvertfald brug for en user tabel
CREATE TABLE `courses`.`users` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`username` VARCHAR( 255 ) NOT NULL ,
`password` VARCHAR( 255 ) NOT NULL ,
`firstname` VARCHAR( 255 ) NOT NULL ,
`lastname` VARCHAR( 255 ) NOT NULL
) ENGINE = MYISAM ;
CREATE TABLE `courses`.`courses` (
`id` INT NOT NULL ,
`name` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM ;
CREATE TABLE `courses`.`courses_desc` (
`courses_id` INT NOT NULL ,
`description` VARCHAR( 255 ) NOT NULL ,
UNIQUE (
`courses_id`
)
) ENGINE = MYISAM ;
Noget i den stil.
--
http://www.fredagspatter.dk[...] - Nyt galleri hver fredag!