mysql help

[wezze]

Hi i need the following db for mutli language script but i get the following error

 

#1062 - Duplicate entry 'home' for key 'id'

 

this is the .sql

 

CREATE TABLE IF NOT EXISTS `modlang` (
  `id` varchar(15) NOT NULL,
  `en` text NOT NULL,
  `fr` text NOT NULL,
  `nl` text NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `modlang`
--

INSERT INTO `modlang` (`id`, `en`, `fr`, `nl`) VALUES
('home', 'Home', 'Accueill', 'Home'),
('members', 'Members', 'Membre', 'Leden'),
('album', 'Album', 'Album', 'Album'),
('calender', 'Calender', 'Calendrier', 'Kalender'),
('contact', 'Contact', 'Contact', 'Contact'),
('register', 'Register', 'S inscrire', 'Inschrijven'),
('guestbook', 'Guestbook', 'Livre d or', 'Gastenboek'),
('movies', 'Movies', 'Film', 'Filmen'),
('link', 'Link', 'Lien', 'Links'),
('welcome', 'Welcome', 'Bienvenue', 'Welkom'),
('info', 'Info', 'Info', 'Info'),
('member', 'Member', 'Membre', 'Lid'),
('fillout', 'Fill out the form below and we will contact you as soon possible.', 'Remplissez le formulaire ci-dessous et nous vous contacterons d?s possible', 'Vul dan snel onderstaand formulier in en wij contacteren u zo snel mogenlijk.'),
('name:', 'Name:', 'Nom:', 'Naam:'),
('birth date:', 'Birth date:', 'Date de naissance:', 'Geboorte datum:'),
('sex:', 'Sex:', 'Sexe:', 'Geslacht:'),
('city:', 'City:', 'Ville:', 'Stad:'),
('country:', 'Country:', 'Pays:', 'Land:'),
('postal:', 'Postal code:', 'Code postal:', 'Postcode:'),
('street:', 'Street:', 'Rue:', 'Straat:'),
('back', 'Back', 'Retour', 'Terug'),
('next', 'Next', 'Suivenant', 'Volgende'),
('login', 'Login', 'login', 'Inloggen'),
('password', 'Password', 'Mot de passe', 'Wachtwoord'),
('fw', 'Forgot password?', 'Mot de passe oubli??', 'Wachtwoord vergeten?');

 

i dont get why i cant use an entry multi times.

 

thx

[requinix]

Sounds like the table isn't empty.

 

i dont get why i cant use an entry multi times.

Because the table definition clearly states that the id must be unique.

[wezze]

lol idd there was alrdy a table with home in it next time ill drop it 1.

 

thx allot