|
|
Hello Jane Endaltseva
I have received by email your response.
Thank you for your help and for fantastic software, It works as you explained, but the field countries is itself . The files I sent were just example, I do not want to lose the link field.
The real example what I want is the following:
1- The field 'Countries' in table 'Example' contains the 'Country_ID' information from table `country` for both fields `Country_english` and `Country_slovak`
2- I have two projects : first project uses `Country_english` field , Second uses `Country_slovak' field
3- Each project depends on the same field 'countries'in 'Example' table , which contains the link field .
So user can choose the language of registration , but the projects for him will be as translators.
The link field must be 'CountryID' and the display field 'County_english' for first project and 'County_slovak' for second project.
Hope I could explain thing.
Thank you very much for your time , hope you can help me.
Thanks again
Hammad
Here is the mysql script example:
--------------------------------------------------------------------------
CREATE TABLE `country` (
`Country_ID` int(11) NOT NULL auto_increment,
`Country_english` char(50) NOT NULL,
`Country_slovak` char(50) NOT NULL,
PRIMARY KEY (`Country_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=176 ;
INSERT INTO `country` VALUES (2, 'Albania', 'Albansko');
INSERT INTO `country` VALUES (3, 'Algeria', 'Alzirsko');
INSERT INTO `country` VALUES (6, 'Armenia', 'Armensko');
INSERT INTO `country` VALUES (9, 'Austria', 'Rakusko');
INSERT INTO `country` VALUES (11, 'Bahrain', 'Bahrain');
INSERT INTO `country` VALUES (15, 'Belgium', 'Belgicko');
INSERT INTO `country` VALUES (24, 'Bulgaria', 'Bulharsko');
INSERT INTO `country` VALUES (38, 'Croatia', 'Chorvatsko');
INSERT INTO `country` VALUES (41, 'Czech Republic', 'Ceska republika');
INSERT INTO `country` VALUES (42, 'Denmark', 'Dansko');
CREATE TABLE `example` (
`ID` int(11) NOT NULL auto_increment,
`Name` char(50) default NULL,
`Surname` char(50) default NULL,
`Countries` longtext,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
INSERT INTO `example` VALUES (1, 'Johan', 'Moore', '2,3,6,9,11,24,41');
|
